AutoSheets

joaomgcd

Contains ads

About this app

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/

╭⋞⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟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.
╰⋞⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⍟⋟

Ratings and reviews

The app was FANTASTIC, for the first 2 weeks. But then it stopped updating 7 days ago and I only noticed yesterday since I didn't get a notification. There was an authentication error message that popped up asking me to log back in but nothing happened when I clicked it and I couldn't find where to log in. When I checked the configuration of the task, it still listed my sheets and the columns ok. Such great potential. I'd really like to keep using it. But this bug is a major roadblock.

I love it, but it can be a bit difficult to actually figure out how to make it work as the guides are either updated or not very detailed

I have it set to post a new row to a sheet every hour, but a few times a day it give an prompt to reauthorize, and stops posting the new row until I notice and click the notification. (Nothing happens when I click the notification, but it does start updating again).

What’s new

- updated target API to 36. Stuff might break. Let me know if it does.