Issue updating Google sheet with Pipedream action

Help
,
1

This topic was automatically generated from Slack. You can find the original thread here.

Zakaria Laabid : Hi everyone i have an issue , i’m using pipedream to detect new row in my sheets and i want to add to every new row a “NO” value to the K column so i did the following things in image to my workflow but it doesn’t wont to work :x

See:

2

Dylan Sather (Pipedream) : Hi , thanks for reaching out. Are you seeing a specific error when your workflow runs? Or is it not updating the correct cell?

3

Zakaria Laabid : It said this

4

Zakaria Laabid : I want to update the K column with the string value “NON”

5

Dylan Sather (Pipedream) : Thanks for the detail. I’ll give you a small working example that I think should address the issue

6

Dylan Sather (Pipedream) : take a look at this example.

I believe you’ll just need to change the Values section of your workflow to:

{{ [[ "NON" ]] }}

Google requires the data passed on that section to be an array of arrays, hence the double square brackets around the data. We’re improving this action specifically in a coming update to make this a little more clear!

7

Dylan Sather (Pipedream) : let me know if that works for you

8

Zakaria Laabid : Oh i exceded the call for today x) This was not 10 000 call ? i only used like 300

9

Dylan Sather (Pipedream) : We set a quota of 10,000 invocations per month, which works out to 333 invocations per day. I just gave you an extra 100 invocations a day today so you can keep testing, though!

10

Zakaria Laabid : Thanks a lot !