Skip to main content
Question

Create and Update Google Docs in realtime with Google Sheets data

  • December 23, 2023
  • 1 reply
  • 276 views

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

ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • December 26, 2023

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!