Saving custom data to Google Sheets

[doroness]

Trying to save data {activeTabUrl} to a google sheet., No matter how tried to format it, the process produces an error when it comes to that stage. Tried several formats:

[
  { "URL": activeTabUrl}
]

[ 
  ["URL"], [ activeTabUrl] 
]

["URL",activeTabUrl]

["URL" , {{activeTabUrl}} ]

[["URL"] , [ "URL",{{activeTabUrl}}]]

[["URL"],[ "URL",activeTabUrl]]

What am I doing wrong? I know the connection to the sheet is ok because 1) I get data from that sheet 2) when I use the "data from - Data Columns" option - it works OK.

You can see my workflow here

[Kholid060]

Try
[["URL"], ["URL", "{{activeTabUrl}}"]]

[doroness]

Hi
Thanks for your answer. It didn't work :( Any other Ideas? Is there something I can do to help you debug this?

[Kholid060]

Automa sending the right payload (first image), and I think the error is on the range that you inputted (second image) when trying to update the spreadsheet cells.

Because with fullurl!A:A range you requested to write the cells on the first column (A) but in the payload, it writes to the second column (B)

[
  ["URL"],
  ["URL","{{activeTabUrl}}"]
]

There're two ways you can fix this, first by changing the range from fullurl!A:A to fullurl!A:B. And second, if you planning to only write on the first column, change the payload into

[
  ["URL"],
  ["{{activeTabUrl}}"]
]

[doroness]

Yep - that was it - it worked. Thanks!

How can I prevent Automa to keep rewriting the values on the same row in the sheet? I want to go down a line with every new update

Resolved - I used the loopData to set ranges dynamically.

Thank you very much!

[Kholid060]

And if you want to debug the network request, you can open chrome://extensions, find Automa and click the background page.