by Stanislav Tvarůžek
Version 4 (November 29, 2021)
Download (775 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 stars | 6 | |
4 stars | 0 | |
3 stars | 0 | |
2 stars | 0 | |
1 star | 0 | |
Reports | 0 |
Rate and review within the app in the Community section.