John Murphy
John Murphy

Reputation: 97

Actions on Google: access Google Spreadsheet

I have a Javascript program that queries a Google sheet with SELECT parameters and returns a row with two cells in JSON format. I want to build an Actions on Google webhook that calls that logic such that I can use the returned JSON values in my conversation.

I am not a programmer so I would appreciate help (and sample code) that might help me do this.

Upvotes: 0

Views: 84

Answers (1)

mandychannyc
mandychannyc

Reputation: 115

There isn't an out of box solution or a sample on our github for your question. However, there is an API for Google spreadsheet which it seems you're already using it

https://developers.google.com/sheets/api/reference/rest

One possible related example of using Google Assistant with the Google Spreadsheet could be vodo drive, which is built by one of the Google Assistant GDEs (Allen, https://twitter.com/afirstenberg) you can learn more through this document

https://docs.google.com/document/d/1gElxZtMpHlTihbUbJoC5jlFf2QYMAv5ruuqreKc9rQw/edit

Upvotes: 1

Related Questions