Sending params from curl to google sheets, could use some examples

A lot of this is confusing to me, and I’m not allowed to spend a lot of time on it, but here’s what I have so far.

workflow:
steps.
trigger
trigger
HTTP API

https://enr2pczxokjg05b.m.pipedream.net
Trigger this workflow on each request
test
Event
cURL
JavaScript
Node
Python2
Python3
PHP
Go
Ruby
dns:
1.2.3.4
ip_address:
92.188.61.181
name:
test
Copy Path

Copy Value
serial:
user@example.com
time:
23902340987234

Then steps.
add_single_row_to_sheet

And I have the sheet info put in, except my first problem is that no matter how I edit the event above, it keeps only giving me params from the initial variables, like user@example etc. How do I make this cell update with the right body params?

There was a node.js cell in between the two, but I deleted it to see if that would fix the issue. Hopefully that didn’t break anything.

If I can get these 2 cells data aligned, the only other thing I’d need to do is form the curl request or are there some other steps or sections outside workflows etc?

Thanks for any hand holding.

Hi there. Do you have a workflow that you’re able to share so I can take a closer look? You can click the blue Share button at the top right of your workflow and share with danny@pipedream.com.

sorry I don’t know enough about this to know if I should given the info I’ve linked through sheets. But the problem I’m seeing is simple enough. I have steps.trigger where I have the curl information replaced, and it replicates to the other tabs.

But then linked to that is steps.add_single_row_to_sheet and if I type in the explorer box event.body. all I get are the old default fields/values. for example, here is the curl:

curl -d '{
  "name": "test",
  "serial": "user@example.com",
  "ip_address": "92.188.61.181",
  "time": "23902340987234",
  "dns": "1.2.3.4",
  "user_agent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_6_4) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.100 Safari/534.30"
}'   -H "Content-Type: application/json"   https://enr2pczxokjg05b.m.pipedream.net

But typing in event.body gives me the options of email, ip, mock, user agent

I’ve even deleted that step and re-added.

Will it still work if I manually put in the event.body stuff?

Are you able to share your workflow with me so I can take a closer look? You can click the blue Share button at the top right of your workflow and share with danny@pipedream.com.

Also, can you confirm the email account you have linked to Google Sheets auth in Pipedream has access to edit the Google Sheet you have linked in the steps.add_single_row_to_sheet in your workflow?

I’ve shared it with you. The account used for auth is the owner of the sheet. Is there some way to define scopes that needs to be done? anyway, take a look and let me know.

Thanks

Interesting. It sounds like there may have been a checkbox that was missed during the auth process with the Google Sheets app. Can you try the below steps to see if this resolves the issue?

  1. Click “Accounts” on the left side of your Pipedream account
  2. Click the 3 dots on the right side of “Google Sheets” and select “Reconnect”
  3. This should kick off the authorization flow again – make sure to check the box that specifically enables access to make changes to files in your Google Drive account (screenshot below)

That was it, thanks.

Ah glad we got it sorted!