Create Google Doc [on 1st Record Only]

Here are the steps I want:

• Google Sheets sends data to Pabbly via Webhook
• Create Google Doc
• Populate Google Doc with each Google Sheets row

I tried using the Pabbly Router:

• Route 1: Create document [1st record]
• Route 2: Populate document [all other records]

Thank you!

Hi @fivehead,

You can manually create a new document in your Google Docs account and then set up your workflow in this manner to achieve your use case.
https://connect.pabbly.com/workflow/share/DERRY1YBUDMFTwljVQZXcAsfAwcIUgg1Bx5RQwcIAnpbFQB7A0JbMQxAU3FfCAVkXhdVP1QLAWVfSwUBVAIDcFBJBQdUV1ctVBkEfw1uCToMUlF5Vjc#

Im also a member like you (not staff). But here is what i suggest.

You can create a Template Document (watch videos on how to transfer data from Google Sheets to Google Doc / Google Slides). It is just mapping the cells to the required places in the Document where you need by placing {{TEXT}} in curly parentheses in the Google Doc / Google Slides.

When you run, it will create new documents for each row. This is what you want. You dont need to use any Router logic here in the workflow.

Im also a member like you (not staff). But here is what i suggest.

You can create a Template Document (watch videos on how to transfer data from Google Sheets to Google Doc / Google Slides). It is just mapping the cells to the required places in the Document where you need by placing {{TEXT}} in curly parentheses in the Google Doc / Google Slides.

When you run, it will create new documents for each row. This is what you want. You dont need to use any Router logic here in the workflow.

I have it mostly working:

• Webhook trigger (simple response, because advanced response isn't working for me?)
• Counter (initial value = 0, increment by 1)
• Router
  
  • IF initial counter = 0
    
    • Create document
  • IF initial counter != 0
    
    • Append to document

If I remove the counter from Pabbly and add a counter column to the spreadsheet (1 = 1st record, 2 = 2nd record, etc), it sometimes works, but other times, the webhook output grabs the last record from the spreadsheet first (as verified by Task History).

Frustrating, for sure.

Hi @fivehead,

You can manually create a new document in your Google Docs account and then set up your workflow in this manner to achieve your use case.
https://connect.pabbly.com/workflow/share/DERRY1YBUDMFTwljVQZXcAsfAwcIUgg1Bx5RQwcIAnpbFQB7A0JbMQxAU3FfCAVkXhdVP1QLAWVfSwUBVAIDcFBJBQdUV1ctVBkEfw1uCToMUlF5Vjc#

The only manual step should be the data inserted into Google Sheets.

You only need to create the document manually once. The point of automation is to automatically add newly add data to that specific document whenever a new row is added to your spreadsheet.

You only need to create the document manually once. The point of automation is to automatically add newly add data to that specific document whenever a new row is added to your spreadsheet.