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

Tasker allows you to use most Google APIs using its HTTP Auth and Request actions

  1. joaomgcd

    joaomgcd Administrator Staff Member

    Joined:
    Feb 3, 2015
    Messages:
    9,479
    Likes Received:
    806
    Glad you got it! :)

    Sorry, but I don't see a ' symbol in that image you linked to. Are you sure it's there?
     
  2. niyonsv

    niyonsv New Member

    Joined:
    Aug 3, 2018
    Messages:
    5
    Likes Received:
    0
    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.
     
  3. joaomgcd

    joaomgcd Administrator Staff Member

    Joined:
    Feb 3, 2015
    Messages:
    9,479
    Likes Received:
    806
  4. Alex Lamson

    Alex Lamson New Member

    Joined:
    Feb 25, 2020
    Messages:
    1
    Likes Received:
    0
    Instead of using the range "A1:Z1000", I think it would be better to use the name of the sheet, like "Sheet1".
     
  5. Zimmy93

    Zimmy93 New Member

    Joined:
    Jan 12, 2016
    Messages:
    2
    Likes Received:
    0
    I can't see the data of the third column but only of the first two. Why?
     
  6. Huskrfreak88

    Huskrfreak88 New Member

    Joined:
    Mar 10, 2020
    Messages:
    1
    Likes Received:
    0
    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?
     
  7. himatech

    himatech New Member

    Joined:
    Apr 25, 2020
    Messages:
    1
    Likes Received:
    0
    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]
     
  8. che100

    che100 New Member

    Joined:
    Jul 29, 2019
    Messages:
    3
    Likes Received:
    0
  9. joaomgcd

    joaomgcd Administrator Staff Member

    Joined:
    Feb 3, 2015
    Messages:
    9,479
    Likes Received:
    806
    Hi. That's explained in step 3 of the tutorial :)

    Sorry for the delay.

    Did you try using values() in AutoTools JSON Read and then flashing %values(1) for example? I think it should contain
    Code (Text):
    [
          "Message Type",
          "Salutation",
          "Message"
        ]
    right?
    If it does, use a For loop in Tasker to go through %values() and in each iteration use JSON Read again to read the array :)
     
  10. che100

    che100 New Member

    Joined:
    Jul 29, 2019
    Messages:
    3
    Likes Received:
    0
    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.
     
  11. che100

    che100 New Member

    Joined:
    Jul 29, 2019
    Messages:
    3
    Likes Received:
    0
  12. joaomgcd

    joaomgcd Administrator Staff Member

    Joined:
    Feb 3, 2015
    Messages:
    9,479
    Likes Received:
    806

Share This Page