Initial Setup Error

[igris]

There seems to be an issue on the initial setup due to blank column from my google sheet. The error shown was 'No data found in Row 2'. Some of the blank column are left unfilled because of choice related question.

EX: If a person choose 1 for the question A, then the next question would direct them to question C instead of question B. Hence the data in column B in the response spreadsheet would be empty.

Is there a solution for this?

 

[Fagun Shah]

All the columns need to have data in 2nd row when you do initial setup. Just add dummy test data in2nd row for all the columns with headers and that should solve the issue.

 

[igris]

All the columns need to have data in 2nd row when you do initial setup. Just add dummy test data in2nd row for all the columns with headers and that should solve the issue.

1. Still facing the same issue after filling in a few rows.
2. Webhook only capture the data up to column F only instead of P.

 

[Pabbly]

1. Still facing the same issue after filling in a few rows.
2. Webhook only capture the data up to column F only instead of P.

Can you record a video and show us how you're doing at your end?

You can make use of Loom for recording a video - https://www.loom.com/

TIA!

 

[igris]

Can you record a video and show us how you're doing at your end?

You can make use of Loom for recording a video - https://www.loom.com/

TIA!

Loom | Free Screen & Video Recording Software

Use Loom to record quick videos of your screen and cam. Explain anything clearly and easily – and skip the meeting. An essential tool for hybrid workplaces.

www.loom.com

Let me know if you have a problem to view the recording.

 

[Fagun Shah]

Here are the things to keep in mind while creating google sheet as trigger integration,

1. All the columns with headers MUST have data in 2nd row for setting up the workflow and pabbly addon.
2. Trigger column(N for you) MUST have data for each row, else it will not send data to the workflow.
3. If you are not sure if there will be data in column N or not(bcoz that is optional) then add one extra column after Column N and use that as trigger and make sure it all have some kind of value when a new rows is added to gsheet.
4. Make sure you check mark "Send On Event" if data is added to sheet manually or by google form.
5. If data is added by third-party API then you need to check mark "Send On Event" and "Send on Schedule" both in pabbly addon.

 

[igris]

Here are the things to keep in mind while creating google sheet as trigger integration,

1. All the columns with headers MUST have data in 2nd row for setting up the workflow and pabbly addon.
2. Trigger column(N for you) MUST have data for each row, else it will not send data to the workflow.
3. If you are not sure if there will be data in column N or not(bcoz that is optional) then add one extra column after Column N and use that as trigger and make sure it all have some kind of value when a new rows is added to gsheet.
4. Make sure you check mark "Send On Event" if data is added to sheet manually or by google form.
5. If data is added by third-party API then you need to check mark "Send On Event" and "Send on Schedule" both in pabbly addon.

I see it now.

Is there a way I can auto generate a predefined value such as "N/A" for the blank cells?

Really appreciate if you could help me on this.

 

[Fagun Shah]

How are you adding data to google sheet?

Also for setting up purpose you can use dummy data in blank cells.

In real execution-only Trigger Column needs to have the data, other cells can be blank.

 

[igris]

How are you adding data to google sheet?

Also for setting up purpose you can use dummy data in blank cells.

In real execution-only Trigger Column needs to have the data, other cells can be blank.

Thank you for your help sir.

Problem solved.

 

[SALUTme]

Hello!
I have a first start in Pabbly connect. I set connect in G.sheets and in Pabbly account.
I add data in google sheets from third-part API. But it's work very rarely.
I keep in mind all of your recomendation from youtube and this forum.

Could you help me with this problem?

 

[SALUTme]

Hello!
I have a first start in Pabbly connect. I set connect in G.sheets and in Pabbly account.
I add data in google sheets from third-part API. But it's work very rarely.
I keep in mind all of your recomendation from youtube and this forum.

Could you help me with this problem?
View attachment 10266
View attachment 10265

If i try add check box to "send all data" or "send custom data", Pabbly sent my message to telegram. But after stop again((

 

[Supreme]

Hey @SALUTme

As we can see from your workflow you are getting data in your workflow properly, if you are getting confused with both the options of "Send On Event" and "Auto Send On Schedule" then the after Google Sheets receives the data from 3rd party application then it takes up to 1 hr to send the data to your workflow.

 

[SALUTme]

Hey @SALUTme

As we can see from your workflow you are getting data in your workflow properly, if you are getting confused with both the options of "Send On Event" and "Auto Send On Schedule" then the after Google Sheets receives the data from 3rd party application then it takes up to 1 hr to send the data to your workflow.

View attachment 10269

Thanks for your answer.
How i can send the data immediately?

 

[Supreme]

Hey @SALUTme

How i can send the data immediately?

If the data is coming from 3rd party application then you need to use both the options "Send On Event" and "Auto Send On Event" add-on in the Pabbly Connects' extinction which will forward the data in 1-hour only, it will not forward the data immediately.

 

[Dme12]

While checking availability of WhatsApp No. by selecting Send all Data. I'm getting an error "Exception: Attribute provided with no value: url". Steps mention in the below video for process one I was following but even then getting same error again and again.

Reference link -

 

[Pabbly]

While checking availability of WhatsApp No. by selecting Send all Data. I'm getting an error "Exception: Attribute provided with no value: url". Steps mention in the below video for process one I was following but even then getting same error again and again.

Reference link -

Please share the workflow name so that we can check how you have done the setup.

 

[Dme12]

As shown in video by clicking on "Send All Data" the automation is working. That's why I'm not using any workflow.

 

[Dme12]

Please share the workflow name so that we can check how you have done the setup.

Please share the workflow name so that we can check how you have done the setup.

This is the workflow I'm using- https://connect.pabbly.com/workflow/mapping/IjM2MTQ2OSI_3D

 

[Supreme]

Hey @Dme12

Could you please share your respective Google Sheet with us at ([email protected]) by creating a new thread in Private Discussion? So that we can look into it and can configure your workflow accordingly.