Cloud automation with Google Sheets

[Oriol Martinez]

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.

Screenshot from the config:

Message after setting that ID and saving/verifying:

Still saying that the field was not provided. 

 

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

 

Regards.

 

 

[Jeremy]

@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).

[Oriol Martinez]

Bit late to reply but thanks Jeremy your answer solved the issue.

Found old info about that on the wiki and here on the forum where the id from Google sheet needs to be specified. Now with the name is much easier.