How do I set up Google Sheets (Get a Cell)?

How To
1

What are you trying to achieve?

I’m developing a chat with Voiceflow and I’ve created a jscript that generates an order number. I need it to verify that it doesn’t exist when it’s generated.

For this I’ve created a spreadsheet in Google Drive where the created numbers will be stored. I need to connect Make >> Webhooks >> Google Sheets (Get a Cell), but I don’t know how to connect Google Sheets (Get a Cell). I don’t know how to fill in the fields. Can someone please help me?

2

Hi @Breakfast4you_SAS, I’m assuming you already made a connection to your google drive to configure the module. Rest of the fields are :

Spreadsheet / Sheet Name : Either you choose it from your drive in the list, either you copy Spreadsheet ID from the URL when you are on your spreadsheet page (like :

‘17wNINwx1ckV9U7EWbvzn_9V-89noBVXzoukZF42MWD7’ (without ')
in
https://docs.google.com/spreadsheets/d/17wNINwx1ckV9U7EWbvzn_9V-89noBVXzoukZF42MWD7/edit?gid=0#gid=0

And in sheet name just type in exactly the sheet name.

For the cell reference, you just type in ‘A3’ (without '). There’s also an option to write in R1C1 notation with rows and columns. If your order number is in one unique cell, this module will work just fine, but if you need additional filtering or search in a database, you’ll need to post the database structure screen to let us help you.