Google Sheets → Google Docs: append new table rows to one document

How To
1

Hi everyone,

I’ve built a scenario in Make that sends new rows from Google Sheets into Google Docs. So far, I can only create a separate document for each new row using a template.

What I’d like to achieve:

  • One continuous overview document in Google Docs.

  • Each time a new row is added in Google Sheets, a new table row should automatically be added to that same document.

  • The table in Docs should keep the gray/white row styling.

My current setup:

  • Google Sheets > Watch New Rows

  • Google Docs > Create Document from Template

What I think I need (but where I’m stuck):

  • Google Docs > Get Document Content

  • Text/Array Aggregator to merge the new row with the existing content

  • Google Docs > Update Document (so the new row is added to the existing file instead of creating a new one)

Question:
What’s the best way to solve this technically in Make? Specifically, how can I append a new table row while keeping the existing table formatting?

Thanks in advance! :folded_hands:

4

Hey Daan,

can you show what the document looks like and where you are adding the data?

Maybe you are looking for the Insert a Paragraph to a Document module?