How to connect an Alexa skill to Google spreadsheet?

I am a student and I have a spreadsheet which has all of my upcoming assignments. I know that skills can connect to an API, is there any way I can get Alexa to read the last line from my Google sheet?

asked Aug 20, 2020 at 21:23 123 1 1 silver badge 12 12 bronze badges

This is really vague. The most straightforward answer is you build a Google Sheets API client into your skill, use it to query your sheet, and then provide that response. But it seems you're looking for something prepackaged.

Commented Aug 24, 2020 at 6:14

To be honest. i haven't tried it yet, but this is new info as i didn't know google had an API for their sheets. ill give it a go. Thanks

Commented Aug 27, 2020 at 14:36

1 Answer 1

The Google Sheets API has Node.js support, which is a common language to write Alexa Skill handler functions in. So what one could do is write a skill in Node.js hosted on AWS Lambda that performed the necessary calls to Google Sheets to retrieve what you need. It's a bit of work, but not extreme and would be a great learning opportunity.

Look around and you might even find some Alexa Skill projects that already do things similar to this.

answered Sep 10, 2020 at 21:51 Adam Bellas Adam Bellas 322 2 2 silver badges 7 7 bronze badges

This question is in a collective: a subcommunity defined by tags with relevant content and experts.