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