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 triggers35 actions6 example workflows1 ready-made templateUnlimited 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.
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.
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 Value→Filter→Create Document From Template→Update Cell Data
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 Row→Date/Time Formatter→Append Text to Document
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 Row→Find or Create Document→Append Text to Document
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.
Schedule→Get Row Data→AI Agent→Create Document
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 Value→Find a Document→Find 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.
Create a document from a template for each new rowTemplate
1. Trigger in Google Sheets
New Spreadsheet Row
2. Action in Google Docs
Create Document From Template
Fields mapped from the earlier steps (a typical setup)
From Google Sheets
To Google Docs
Client name
Client name placeholder
Project
Project placeholder
Amount
Amount placeholder
Start date
Start 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.
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.
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.