Google Spreadsheets Integration

by Stanislav Tvarůžek

Version 4 (November 29, 2021)

Download (99 downloads)

The flow sends JSON payload directly to a Google spreadsheet via a web service.

The Send Current Location flow sends your current latitude, longitude, and value "Hello".

The Send QR Code Value flow reads a QR Code (ZXing BarCode scanner app must be installed) and sends the value from the QR Code. Latitude and longitude values are set to "N/A" to pass the validation in the web app.

The values are inserted using Google Apps Script into the spreadsheet.

You can then further process data using Google Apps Script to send emails, create docs, spreadsheets, save files to your Google Drive and make HTTP requests.

This opens brand new possibilities for how you can send data from the Automate app and process them further in Google Spreadsheets.


Spreadsheet:
https://docs.google.com/spreadsheets/d/1VZEp-ru9BH9AQSNHzRxnJZx1Nabviz6UiN9PIelOjA8

Web app code and setup:
https://gist.github.com/stvaruzek/1db65358f7fcf1a0f0b62f6f36ef2fbe

Enjoy!

Leave a comment how you use it in your flows.

5.0 average rating from 3 reviews

5 stars
3
4 stars
0
3 stars
0
2 stars
0
1 star
0
Reports
0

Rate and review within the app in the Community section.