AutoSheets

AutoSheets allows you to view/edit your Google Sheets data in/from Tasker!

It currently supports the following actions:

• Add Rows: append rows of data to the end of a sheet or insert them somewhere in the middle of the sheet
• Add Sheet: add a new Sheet (tab) at the bottom of your spreadsheet
• Create Spreadsheet: create a whole new spreadsheet
• Delete Cell Content: clear the contents of cells without actually removing lines of columns from the sheet
• Delete Rows/Columns: actually remove rows and columns from sheets along with their content
• Duplicate Sheet: Create a new sheet inside a spreadsheet which is a copy of an existing sheet
• Format Cells: change the appearance of cells on your sheets like background or text color
• Get Cell: 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 Data: get multiple rows/columns of data at the same time. Optionally name the output data as multiple arrays for easier data parsing
• Get Spreadsheet: get info on a spreadsheet itself like its ID, sheet names, etc
• Insert Empty Rows/Columns: Simply insert new rows/columns with no content
• Update Cells: 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/