• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Initial Setup Error

igris

Member
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?
 

Attachments

  • initial setup.PNG
    initial setup.PNG
    27.8 KB · Views: 68
Last edited:

Fagun Shah

Well-known member
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

Member
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.
 

Attachments

  • Initial Error.PNG
    Initial Error.PNG
    31.7 KB · Views: 63
  • Webhook.PNG
    Webhook.PNG
    21.9 KB · Views: 65
Last edited:

Fagun Shah

Well-known member
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

Member
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

Well-known member
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.
 

SALUTme

Member
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?
1651094942831.png

1651094895675.png
 

SALUTme

Member
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

Well-known member
Staff member
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.

1651124066996.png
 

SALUTme

Member
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

Well-known member
Staff member
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

Member
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

Administrator
Staff member
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

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

Supreme

Well-known member
Staff member
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.
 
Top