Connect Smartsheet and Google Sheets

Project teams often plan in Smartsheet while clients, finance or another department work in Google Sheets. FlowMattic passes rows between the two from your WordPress site: new and changed Smartsheet rows land in Google Sheets for reporting, and rows added in Google Sheets become Smartsheet tasks or whole project sheets built from your template.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in Smartsheet4 triggers

Do this in Google Sheets19 actions

1. TriggerNew Row

2. ActionAdd New Row

When Smartsheet fires New Row, FlowMattic runs Add New Row in Google Sheets with the data from that event.

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

Smartsheet and Google Sheets 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

Copy each new Smartsheet row into Google Sheets

People who never open Smartsheet, such as a client or the finance team, get a Google Sheet that gains a row every time the project plan does.

New RowAdd New Row

View the template

Keep status and due dates current in the report sheet

When a Smartsheet row changes, find its copy in Google Sheets by task ID and update it, so the shared report shows today's status rather than last week's.

Updated RowLookup Row DataUpdate Row

Turn request rows from Google Sheets into Smartsheet tasks

Work requests collected in a Google Sheet, often from a Google Form, are added to the Smartsheet project plan so the delivery team picks them up where they schedule work.

New Spreadsheet RowAdd Row to Sheet

Start a project sheet from a template for each new client

Sales adds a signed client to a Google Sheet. A Smartsheet sheet is created from your project template and shared with the account lead, ready for kickoff.

New Spreadsheet RowNew Sheet From TemplateShare Sheet

Send only approved budget lines to Smartsheet

Finance marks lines as approved in a Google Sheets column. A Filter passes only the approved ones, which are added to the Smartsheet budget tracker.

Update Specific Column ValueFilterAdd Row to Sheet

Log Smartsheet comments in a review sheet

Each comment left on a Smartsheet row is written to a Google Sheet with the author and date, giving account managers one list of open questions to go through on client calls.

New CommentAdd New Row

Move a week of Google Sheets rows into Smartsheet

A weekly Schedule reads the rows a team logged in Google Sheets, loops over them with Iterator and adds each to Smartsheet, for teams that prefer a weekly hand-off.

ScheduleGet Row DataIteratorAdd Row to Sheet

Set up: new Smartsheet rows in Google Sheets

When you finish, every row added to your Smartsheet sheet is copied as a new row into a Google Sheet.

Match the columns
Give the Google Sheet a header row that mirrors the Smartsheet columns you want, for example Task, Owner, Status and Due date, plus a Task ID column.
Connect both accounts
Add a Smartsheet connection and a Google Sheets connection under Connects, each with access to the sheet you will use.
Start from New Row
Create a workflow with the Smartsheet New Row trigger, pick the sheet, and add a test row so FlowMattic captures its cells.
Map Add New Row
Add a Google Sheets step with Add New Row, choose the spreadsheet and tab, map each Smartsheet cell to its column, test and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up

From Smartsheet	To Google Sheets
Row ID	Task ID
Task name	Task
Assigned to	Owner
Status	Status
Due date	Due date

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

The column names above are examples. Both apps pass whatever columns your sheets have, so match them to your own headers.
Store the Smartsheet row ID in the Google Sheet. It is the value Lookup Row Data searches on when an Updated Row workflow needs to find the matching row.
Running both directions on the same pair of sheets can loop, as each write looks like a new change. Sync one direction per sheet, or use a Filter to skip rows the workflow wrote.

Smartsheet

Integration page

Triggers (4)

New AttachmentTriggers when a new attachment is added to a row.
New CommentTriggers when a new comment is added.
New RowTriggers when a new row is added.
Updated RowTriggers when a row is updated.

Actions (16)

Add Discussion to RowAdds a discussion to row.
Add Row to SheetAdds rows to the sheet.
Add Attachment to RowAdds a file attachment to a row.
Copy FolderCopies the folder.
Copy WorkspaceCopies the workspace.
Create WorkspaceCreate a workspace.
Move Row To Another SheetMoves row to another sheet.
Copy Row To Another SheetCopies row to another sheet.
Update Existing RowUpdate existing row in a sheet with new values.
New Sheet From Existing SheetCreate a new sheet from the existing sheet.
New Sheet From TemplateCreate a new sheet from the template.
Share SheetShares a sheet.
Share WorkspaceShares a workspace.
Send SheetSend a sheet via email (as PDF or Excel).
Send RowSend a row via email.
Get RowGet specific row of a sheet.

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

Why run this pair with FlowMattic

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

Each team keeps its own tool

Planners stay in Smartsheet and everyone else stays in Google Sheets, with FlowMattic carrying the rows between them in both directions.

Big sheets do not cost more

Runs are unlimited on every plan, so a busy project with hundreds of row changes a day costs the same as a small one.

More than copying rows

Smartsheet actions such as New Sheet From Template, Share Sheet and Send Sheet let a Google Sheets row start real project work, not just a mirrored line.

Common questions

How does the Smartsheet Google Sheets integration work?

FlowMattic watches one app for new or updated rows and writes them to the other. Smartsheet rows can become Google Sheets rows, and Google Sheets rows can become Smartsheet rows, tasks or new sheets, all set up on the FlowMattic builder in WordPress.

Can I keep the two sheets in sync both ways?

Yes, with two workflows, one per direction. Keep a shared ID column in both and use a Filter so a row written by one workflow does not start the other again.

Do Smartsheet attachments come across?

New Attachment is a trigger, so you can log each attachment's name and link in a Google Sheet. The file itself stays in Smartsheet.

Can a Google Sheets row update an existing Smartsheet row?

Yes. Keep the Smartsheet row ID in the sheet and use Update Existing Row when a Google Sheets row changes, for example from New Or Updated Spreadsheet Row.

Can Smartsheet email a report when the sheet changes?

Yes. Add Send Sheet after any trigger to email the Smartsheet sheet as a PDF or Excel file, or Send Row to email one row.

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

Start automating Smartsheet and Google Sheets

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

Try FlowMattic free See pricing

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

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