• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Can Data directly from Row 4 of google sheets be connected while initial set up?

Status
Not open for further replies.

Gaurav

Member
Can data directly from row 4 of google sheets be connected while doing the initial set up for connecting google sheet to pabbly connect?

In the first row I have the category title of the information. In the second row I have column numbers which I have used in the formula in the other sheet of the same google sheet. The main header for the data is in row 3 and the data starts from row 4.

I want to trigger an action using the data from row 4. But during the initial set when I enter the trigger column as BL, then the data sent to the pabbly connect is from row 2 i.e. "Test data sent successfully 0, 1, 2, 3, 4, 5, 6, ..." etc. which are column numbers. If I put enter BL3 then it show error "No data found in row 2".

How can I set up?
 

Attachments

  • Screenshot 2025-02-12 at 21.48.10.png
    Screenshot 2025-02-12 at 21.48.10.png
    317 KB · Views: 57
  • Screenshot 2025-02-12 at 21.58.28.png
    Screenshot 2025-02-12 at 21.58.28.png
    314.1 KB · Views: 52
  • Screenshot 2025-02-12 at 21.58.48.png
    Screenshot 2025-02-12 at 21.58.48.png
    314.4 KB · Views: 48

ArshilAhmad

Moderator
Staff member
Hi @Gaurav,

No, the data in the first row of your spreadsheet is treated as the headers of your spreadsheet, and it's not possible to send data from any other row by clicking the 'Send Test' button.
 

Fagun Shah

Well-known member
Hi @ArshilAhmad,

Thank you for your reply. Is there any way to do it? Because it will be difficult for me to change the data in the sheet.
There is no workaround for this, all automation softwares like pabbly allows only 1-header row without merged cells.

That is how google sheet api works.
 
Status
Not open for further replies.
Top