Creating a Webhook to pull the last row of data from a google sheet file when triggered

Dev
1

Hi - I’m new to pipedream and have a limited amount of coding knowledge but enough to be semi-dangerous.

I am trying to create a script so I do not need to pay for Zapier to do this.

I want to be able to pull the last line of a google sheet file and pull the data and put it into a webhook when it’s updated.

Currently I have a trigger set for Google sheets "New Updates (Instant from Google Sheets) which will run when a new row gets entered into the sheets file. - Then I have a Discord HTTP POST to a webhook in a JSON file format and have tried to put in the variables and it will only pull the values from when I created the document using Row one on sheets which is my Colum headings.

My problem is I can’t seem to get the variables to go to the last published row and send the current data to the webhook. It keeps pulling Row 1.

Any help would be much appreciated.

Thanks

2

Hi @stevenaernst,

My problem is I can’t seem to get the variables to go to the last published row and send the current data to the webhook. It keeps pulling Row 1.

For this you’ll need a basic node.js code in the custom expression to pull the last published row. I would recommend you to watch this Pipedream university to understand how to do it