AutoSheets allows you to view/edit your Google Sheets data in/from Tasker!
It currently supports the following actions:
-
: append rows of data to the end of a sheet or insert them somewhere in the middle of the sheet
-
: add a new Sheet (tab) at the bottom of your spreadsheet
-
: create a whole new spreadsheet
-
: clear the contents of cells without actually removing lines of columns from the sheet
-
: actually remove rows and columns from sheets along with their content
-
: Create a new sheet inside a spreadsheet which is a copy of an existing sheet
-
: change the appearance of cells on your sheets like background or text color
-
: simple way to get the value of a single cell on your sheet based on its location or the value of a cell on a different column (great for Cloud Variables)
-
: get multiple rows/columns of data at the same time. Optionally name the output data as multiple arrays for easier data parsing
-
: get info on a spreadsheet itself like its ID, sheet names, etc
-
: Simply insert new rows/columns with no content
-
: update the content of cells without inserting any new rows/columns
As an example you could use AutoSheets to add Cloud Variables to Tasker. Check here: https://forum.joaoapps.com/index.php?resources/cloud-variables.522/
Check out more AutoSheets examples here: https://forum.joaoapps.com/index.php?resources/categories/autosheets.38/
╭⋞⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟IMPORTANT NOTE⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⋟
(WARNING: YOU MUST HAVE TASKER INSTALLED FOR THIS APP TO BE OF ANY USE: AutoSheets is only usable as a plugin in Tasker. Please don't rate it negatively because of this.)
Please contact me if anything is wrong and I'll respond to you promptly and try to fix it as soon as I can. Thank you.
╰⋞⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⋟