Jump to content

Cloud automation with Google Sheets


Recommended Posts

Hi, 

I'm trying to export some data from a Request to Google Sheets.
Following the wiki and after setting the connection between Google and Hornbill on KeySafe I'm adding the Cloud Automation box on the Business Process.

After setting all the parameters I'm facing the following message "Missing required property: spreadsheetId" I'm adding the ID from Google Sheets but it don't remains on the fields.


image.png.665a2059e038fe9cdd516da112d77d24.png

Screenshot from the config:

image.png.0338b81b224d9b8292f6c51afcd935a1.png

Message after setting that ID and saving/verifying:

image.png.fd9b613b0ffa0436af1e905afe1424c2.png

Still saying that the field was not provided. 

 

There's something that I'm missing or doing wrong?

 

Regards.

 

 

Link to comment
Share on other sites

@Oriol Martinez when added this information in the spreadsheet id, if you have set up your account correctly in the keysafe then you should be able to type and search for the Google Sheet's name and then select it. The sheet needs to be shared or created with the account that you link in the keysafe.

It might also be a good idea to include the Sheet Name even is this is Sheet 1 (as per default).

  • Like 1
Link to comment
Share on other sites

  • 2 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...