Create Google Doc [on 1st Record Only]

[fivehead]

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

My question is: How do I create only one Google Doc? I don't want to make a new document for each row.

I tried using the Pabbly Router:

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

The problem is that Route 2 can't map to the document created in Route 1.

Thank you!

 

[ArshilAhmad]

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.

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[nirk12]

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.

 

[fivehead]

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.

Thanks for your response! But I don't want a new document for each row - I only want 1 document that will be filled in with data taken from the spreadsheet.

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

...but the counter isn't working as expected :-(

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.

 

[fivehead]

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.

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

Haha, but what is the point of an automation tool then? ;-)

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

 

[ArshilAhmad]

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.

 

[fivehead]

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.

Agree to disagree, but thanks for the suggestion. I figured it out on my own, thanks!