tr Skip to content
Black Friday Lifetime FlowMattic from $399 One payment, unlimited workflows. Ends in --Days --Hrs --Min --Sec See the deal

Connect Google Sheets and Google Docs

Plenty of documents start life as a row: a proposal, an offer letter, a certificate or a client report. FlowMattic reads Google Sheets from your WordPress site and fills Google Docs templates, appends text to running documents and keeps prices or terms current, so the sheet stays the source and the documents follow.

6 triggers 35 actions 6 example workflows 1 ready-made template Unlimited runs

Try a pairing

When this happens in Google Sheets6 triggers

Do this in Google Docs16 actions

1. TriggerNew Spreadsheet Row
2. ActionCreate Document From Template

When Google Sheets fires New Spreadsheet Row, FlowMattic runs Create Document From Template in Google Docs with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Google Sheets and Google Docs workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Google Sheets app icon Google Docs app icon Ready-made template

Create a document from a template for each new row

Each row fills the placeholders in your Google Docs template, producing a named document per client, student or order without copying and pasting.

New Spreadsheet RowCreate Document From Template

View the template
Google Sheets app icon Google Docs app icon

Generate a proposal when the row is marked ready

Sales fills in the row over a few days and sets Status to Ready. A Filter waits for that value, the proposal is created and its link is written into the row.

Update Specific Column ValueFilterCreate Document From TemplateUpdate Cell Data

Google Sheets app icon Google Docs app icon

Append each new row to a running log document

Meeting decisions or changelog entries added to a sheet are appended as a dated paragraph to one shared document, which is easier to read than a long spreadsheet.

New Spreadsheet RowDate/Time FormatterAppend Text to Document

Google Sheets app icon Google Docs app icon

Keep one notes document per client

Find or Create Document opens the doc named after the client, creating it the first time, and the new row's notes are added at the end.

New Spreadsheet RowFind or Create DocumentAppend Text to Document

Google Sheets app icon Google Docs app icon

Write a weekly report document from the sheet

Each Friday a Schedule reads the week's rows, an AI Agent step writes a short summary of what changed, and a new Google Doc holds the report for managers.

ScheduleGet Row DataAI AgentCreate Document

Google Sheets app icon Google Docs app icon

Update a price in a published document when the sheet changes

When the price column changes, Find and Replace Text swaps the old figure for the new one in your rate card or terms document, so the two never disagree.

Update Specific Column ValueFind a DocumentFind and Replace Text

Set up: a document for each row

By the end, adding a row to your sheet creates a Google Doc from your template with that row's values filled in.

  1. Prepare the template

    Write the document in Google Docs and put placeholders where row values go, named after your column headers so mapping is easy.

  2. Connect Google

    Add Google Sheets and Google Docs connections under Connects in FlowMattic.

  3. Trigger on new rows

    Start with Google Sheets New Spreadsheet Row, pick the spreadsheet and tab, and add a test row.

  4. Fill the template

    Add Google Docs Create Document From Template, choose the template, name the new document and map each placeholder to a column.

  5. Test and turn on

    Test the step, open the new document to check every placeholder was replaced, then switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up
Create a document from a template for each new row Template
  1. Google Sheets app icon 1. Trigger in Google Sheets New Spreadsheet Row
  2. Google Docs app icon 2. Action in Google Docs Create Document From Template

    Fields mapped from the earlier steps (a typical setup)

    From Google SheetsTo Google Docs
    Client nameClient name placeholder
    ProjectProject placeholder
    AmountAmount placeholder
    Start dateStart date placeholder
Built on the FlowMattic canvas. Test each step with real data, then switch the workflow on.

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

  • On this page, documents are made or changed in response to a sheet event, a Schedule or a Webhook.
  • Column names above are for example. Each placeholder in the template must match one you map in the step, so open the first test copy and look for any left unfilled.
  • If a workflow writes a link back into the sheet it watches, use a column trigger rather than New Or Updated Spreadsheet Row so the write does not start it again.
Google Sheets app icon

Google Sheets

Integration page

Triggers (6)

  • New Spreadsheet RowTrigger when a new row is added to the spreadsheet
  • New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
  • Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
  • Update Cell DataTrigger when any cell is updated in the spreadsheet
  • Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
  • Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

  • Add New RowAdd a new row with mapped data
  • Update RowUpdate existing row in specific spreadsheet with mapped data
  • Delete RowDelete row by ID in specific spreadsheet
  • Clear Row DataClear data or row by ID in specific spreadsheet
  • Lookup Row DataSearch for data in specific spreadsheet
  • Get Cell DataGet data for particular cell in specific spreadsheet
  • Update Cell DataUpdate data for particular cell in specific spreadsheet
  • Get Row CountGet total number of rows in specific spreadsheet
  • Get Row DataGet rows data from the sheet based on specified range
  • Create Spreadsheet ColumnCreate a new column in specific spreadsheet
  • Create New SheetCreate a new sheet in specific spreadsheet
  • Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
  • Copy SheetCopy a sheet to another or within the same spreadsheet
  • Get RowsRetrieve rows in JSON format for use with Iterator
  • Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
  • Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
  • Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
  • Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
  • Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library
Google Docs app icon

Google Docs

Integration page

Actions (16)

  • Create DocumentCreate a new Google Doc with optional content
  • Create Document From TemplateCreate a new document from a template and replace placeholder variables
  • Get Document ContentRetrieve the full content and metadata of a Google Doc
  • Find a DocumentSearch for a specific document by name
  • Find or Create DocumentFind a document by name, or create it if not found
  • Batch Update DocumentPerform multiple updates using JSON requests (Advanced)
  • Insert TextInsert text at a specific position in a Google Doc
  • Append Text to DocumentAppend text to the end of an existing document
  • Find and Replace TextFind and replace text with case sensitivity support
  • Format TextFormat text with bold, italic, colors, and other styling options
  • Delete Content RangeDelete content between start and end index
  • Insert ImageInsert an image at a specific position in a Google Doc
  • Replace ImageReplace an existing image in a Google Doc with a new one
  • Insert TableInsert a table with specified rows and columns
  • Insert Page BreakInsert a page break at specified position
  • Update Document PropertiesUpdate document properties like background color, margins, and page settings

Why run this pair with FlowMattic

Google Sheets and Google Docs connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

The sheet stays the source

Data is edited in one place, and documents are created or updated from it, which removes the copy step where mistakes creep in.

As many documents as rows

Runs are unlimited, so generating hundreds of certificates or letters at term end costs no more than one.

Runs from your WordPress site

Workflows run on your own server, so client details move between your Google files without passing through another automation service.

Common questions

How do I connect Google Sheets to Google Docs?

Add both Google accounts under Connects in FlowMattic, start a workflow with a Google Sheets trigger such as New Spreadsheet Row, and add a Google Docs action like Create Document From Template or Append Text to Document.

Can I style parts of the generated document?

Yes. After the document is created, Format Text can make chosen text bold, italic or coloured, and Update Document Properties can change margins or page settings.

Can I add a table of rows to a document?

Yes. Read the rows with Get Row Data and use Insert Table in Google Docs, or loop over the rows with Iterator and append each as a line.

Can I add images to the generated document?

Yes. If a column holds an image URL, Insert Image can place it in the document, and Replace Image can swap a placeholder image in a template.

What happens to rows added before the workflow?

New Spreadsheet Row reacts to rows added after the workflow is on. For older rows, run a one-off workflow that reads them with Get Row Data and loops with Iterator.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Google Sheets and Google Docs

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 27 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Google Sheets integration 2.2.4, Google Docs integration 1.0.0.