Newbie question about webhook and data/values from Google Sheet (using Glide App)

Hi,
I am still new to Pipedream. So far I had used it once and it is working okay.
But I now want to try to use the webhook.
Right now I have a workflow that is working.
If a new row is added to a Google Sheet, it will send out an email with some data from that newly added row.
It is a little bit difficult to explain but I will give it a go.
I am using Glide apps to create an app.
In there I want to place a button that will trigger the webhook.
(There is no new row added to the Google Sheet, that is why I want to use the webhook)
In Glide apps, I am checking if a certain user has an email address filled in and if they want to receive a notification.
If this is set to receive notifications, then the webhook will be triggered and an email will be sent to the email address of that certain user.
I know that when a new row is added to the Google Sheet, during the test phase, you can see different values and you can use those values to place them in the email.
When you create a webhook, can you also see and use the values in the test phase?
I hope my question is clear.
I did not do any testing yet with webhooks. I thought I will ask my question first here before I use my time in testing and see if it is possible.
Thanks in advance.

Hi @winnetherlands2022

Yes you absolutely can, here’s a short video to show you how to use data passed in webhooks during development of your workflow.

Hope this helps!

Hi @pierce,
Thanks for the reply. I will have a look at this tomorrow and will try to see which values I will get from the webhook.
My data comes from a Google Sheet/Glide App, and from that data, I want to use the email address, so an email can be sent to that email address.
I will let you know, if I have more questions, or if it is working the way I want to.
Again, Thanks. :slight_smile:

@pierce,
Okay, I did several tests.
At first, it looked like it was working.
The trigger is working.
The sending an email part is not working the way it should.
I have created the trigger/webhook, and copied the generated URL in the app.
In the app, I have set which value it needs to forward.
In the test, I can see what has passed through.
in the body, I saw the value and selected “select path”
The test was good.
In the send email part, I have pasted the select value.
(I also choose the option “Select path” that was given behind the value.)
A test email was sent. This went fine.
But if in the app a place a different email address, I am getting an error in the workflow.
“Cannot read property ‘value’ of undefined
(send_email)”
When I place the first email back again, it is working.
I tried it several times, but no luck.
As far as I can see, the trigger is working without any problems.
It is the sending email that is giving the problem.
I compared a good run with an error run, but they all look the same.
The only difference is the email address.
The idea is, that no matter what email address is given, it should sent out an email.
I am not sure how else to describe the problem, but I hope this is a bit clear.
And I hope you can help me further.
Many thanks in advance.

@pierce,
A small addition to this all.
Today I did one more test, and again it failed.
The strange thing is, that I am using the same email address as yesterday.
Yesterday it was successful, but today it failed.
Very strange.
The error I got today was:
TypeError
Cannot read property ‘value’ of undefined

Hi @winnetherlands2022

The error Cannot read property <property name here> of undefined means that your code or pre-built action code is passed data that is incomplete.

This means that possibly the incoming data has changed or is missing.

To debug, you can use logging in Node.js steps to see where data is missing.

You can also use the built in Filter action to filter out data that shouldn’t be processed.

@pierce,
It is solved.
Somewhere, somehow, there was an error.
I removed the workflow, and in Glide, I removed the custom action and started from scratch.
Now it looks like it is working. :slight_smile:

1 Like