This is a plugin for the Tasker App. Using the plugin you can query and update Google Spreadsheets from a Tasker task.
o Requires Tasker is installed.
o Supports multiple Google Drive accounts
o Supports Tasker variables
o Supports offline buffering(PRO feature).
o Supports setting cell foreground and background colors.
o Append a row of data or update a specific location.
o Query entire sheet or only the last row.
o Query output in four different formats(rows, columns, json, merged).
o Build in test functionality.
Please check the app's help pages for details regarding variables.
Additional support: https://www.uitcon.com/pages/spreadsheet-tasker-plugin.html