Question

Create and Update Google Docs in realtime with Google Sheets data

  • 23 December 2023
  • 1 reply
  • 66 views

Userlevel 1

I am trying to set up a system for clients where data I input into a Google Sheet is automatically pulled into a Google Doc, but am having trouble.

The sheet would be something like: Column A: Name, Column B: Address, Column C: Email,  Column D: Notes with rows of data for different names and info.

The google doc would, in theory, have all the records in the sheet in a single file with updated fields correlated to the rows in the sheet.


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +6

Hi there @jkirkenir,

Welcome to the Community! 🎉

Here is how I see the Zap for the workflow that you have in mind:

  1. Trigger: Google Sheets - New Spreadsheet Row
  2. Action: Google Docs - Append Text to Document OR Create Document from Template

Hopefully, this helps!