Tasker Add a row of data to a Google Spreadsheet (no plugins) 2019-07-08

Hi Joao, I shared a sample Sheets document to your email (support@joaoapps.com) with editing capability for checking the cells and value. Please check the issue by tapping the cells with numbers and check the value (at top in desktop; at bottom in phone app). You can see the apostrophe symbol in front of all values containing numbers and nothing in front of values starts with alphabets. All the datas are pulled from Tasker variable values and those don't contain any apostrophe symbol.

 

Instead of using the range "A1:Z1000", I think it would be better to use the name of the sheet, like "Sheet1".

 

I can't see the data of the third column but only of the first two. Why?

 

Good morning! Hoping someone is still active on this thread.

I went through the Cloud Project process, got that all set up without issue. When I run the "sheet test" task imported from this process, nothing is added to my Google Sheet!

I added flash tasks along the way to ensure the variables were being passed correctly into each step, and they are, it's just not writing anything. No errors are occurring, nothing *appears* wrong but I am, admittedly, a bit outside my comfort zone.

Anything I can check to see why this task is not writing to the sheet as expected?

 

Hi João - I hope you and your family are safe and thanks for the great job you're doing on Tasker!!

I've decided to imitate this project in an opposite way i.e. reading from a sheet instead of updating it. I can't get my head around how to make AutoTools JSON Read fetch the array of arrays. Here is a sample of the API response:

Code (Javascript):

{
  "range": "'whatsapp-contacts-20200430'!AU1:AW1",
  "majorDimension": "ROWS",
  "values": [
    [
      "Message Type",
      "Salutation",
      "Message"
    ]
  ]
}

How can I convert the field "values" from a javascript format (sample below) to AutoTools JSON Read format? For a simple array, it would be values() and that's it. But for an example like the one below, values()() doesn't work.

Code (Javascript):

values[i][j]

 

Hi João,thanks for the cool work.
How to make your own RedirectURL https://tasker.joaoapps.com/auth.html ?

 

João please tell me how to implement it?
An incoming call to a two-sim telephone, tasker writes in Google Spreadsheet a table the SIM card number 1 or 2.

 

You misunderstood. I want my own personal domain, https://my own personal domain.com/auth.html
Is it possible?