tr Skip to content

Connect Google Sheets and Google Drive

Use a Google Sheet as the control panel for your Drive. A new row can create a client folder, a status change can move or export a file, and each new file in a folder can add its own row. FlowMattic runs these workflows from your WordPress site and writes the folder and file links back into the sheet.

10 triggers 47 actions 6 example workflows 10 ready-made templates Unlimited runs

Try a pairing

When this happens in Google Sheets6 triggers

Do this in Google Drive28 actions

1. TriggerNew Spreadsheet Row
2. ActionCreate a Folder

When Google Sheets fires New Spreadsheet Row, FlowMattic runs Create a Folder in Google Drive 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 Drive 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 Drive app icon

Create and share a Drive folder for each new client row

Agencies and accountants add one row per client. The workflow creates the client's folder, shares it with the email in the row and writes the folder link back next to the name.

New Spreadsheet RowCreate a FolderShare FolderUpdate Row

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

Issue a certificate file to each name on the finishers sheet

Course runners add a row when someone completes. Drive gets a certificate file with their name and date, shared with them, so nobody types certificates by hand.

New Spreadsheet RowCreate File From TextShare File

View the template
Google Sheets app icon Google Drive app icon Ready-made template

Save a weekly written summary of a metrics sheet to Drive

Every week an AI agent reads the rows of your numbers sheet and writes a short report of what moved. The report lands in a Drive folder for anyone who wants the history.

ScheduleGet Row DataAI AgentCreate File From Text

View the template
Google Sheets app icon Google Drive app icon

Move a file to the approved folder when its row says Approved

Reviewers change a status column instead of dragging files around. The workflow finds the file named in the row and moves it to the folder for approved work.

Update Specific Column ValueFind FileMove File

Google Sheets app icon Google Drive app icon

Export a finished document to PDF and post the public link

Mark a row Final and the document whose ID sits in that row is exported to PDF, given an anyone-with-the-link share, and the link is written into the row for the client.

Update Specific Column ValueExport File to PDFShare File with AnyoneUpdate Cell Data

Google Sheets app icon Google Drive app icon

Add a row to an inventory sheet for each new file

When a file lands in the shared folder, its name, link and date go into a new row, so the folder has a list people can sort and filter.

New File in FolderAdd New Row

Set up: a shared folder per client row

At the end, each new row in your client sheet has its own Drive folder, shared with the client, with the link in the row.

  1. Connect both Google apps

    Add a Google Sheets connection and a Google Drive connection under Connects, using an account that owns the sheet and the parent folder.

  2. Prepare the sheet

    Give the sheet columns for client name, client email and folder link, and add one sample row.

  3. Trigger on New Spreadsheet Row

    Create a workflow with the Google Sheets New Spreadsheet Row trigger, pick the spreadsheet and sheet, and capture the sample row.

  4. Create and share the folder

    Add Google Drive Create a Folder named after the client, then Share Folder with the folder ID from that step and the email from the row.

  5. Write the link back

    Add Google Sheets Update Row, map the folder link into the folder column, test the run and switch it on.

Create and share a Drive folder for each new client row
  1. Google Sheets app icon 1. Trigger in Google Sheets New Spreadsheet Row
  2. Google Drive app icon 2. Action in Google Drive Create a Folder
  3. Google Drive app icon 3. Action in Google Drive Share Folder
  4. Google Sheets app icon 4. Action in Google Sheets Update Row

    Fields mapped from the earlier steps (a typical setup)

    From Google SheetsTo Google Sheets
    Client nameFolder name
    Client emailShare with email
    Folder IDFolder to share
    Folder linkFolder link column
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

  • To log files as they arrive, start from New File in Folder. Updated File can then refresh that file's row with Lookup Row Data and Update Row when it changes.
  • Share, move and export steps need a file or folder ID. Keep the ID in a sheet column when a workflow creates the item, or look it up with Find File or Find Folder.
  • The column names in the mapping are an example. Use the headers your own sheet has.
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 Drive app icon

Google Drive

Integration page

Triggers (4)

  • New FileTriggers when any new file is added (inside of any folder)
  • New FolderTriggers when a new folder is added directly to a specific folder
  • New File in FolderTriggers when a new file is created, moved, or uploaded to a specific folder
  • Updated FileTriggers when a file is updated in a specific folder

Actions (28)

  • Upload a FileUpload file to your Google Drive selected folder
  • Create a FolderCreate a new folder in your Google Drive
  • Create a Sub FolderCreate an empty sub folder
  • Share FolderShare the folder by its ID to an email
  • Share Folder with AnyoneGenerates the link to share with anyone on the internet
  • Share FileShare any file by its ID to an email
  • Share File with AnyoneGenerates the link to share with anyone on the internet
  • Find FileSearch for a specific file by name
  • Find FolderSearch for a specific folder by name
  • Find Multiple FilesSearch for multiple files by name or within a specific folder
  • Retrieve File or Folder by IDGet a file or folder by its ID
  • Create File From TextCreate a new file from plain text
  • Create ShortcutCreate a shortcut to a file
  • Copy FileCreate a copy of the specified file
  • Move FileMove a file from one folder to another
  • Update File/Folder NameUpdate the name of file or folder
  • Delete FileDelete the file
  • Create Shared DriveCreate a new shared drive in your Google Drive
  • Export File to PDFExport a document or file to PDF format
  • Download File to Media LibraryDownload a file from Google Drive and add it to WordPress media library
  • List Files in FolderList all files in a specific Google Drive folder
  • Update File ContentReplace the content of an existing file
  • Trash File/FolderMove a file or folder to the trash
  • Restore File from TrashRestore a previously trashed file or folder
  • Empty TrashPermanently delete all files in the trash
  • Add Comment to FileAdd a comment to a file in Google Drive
  • List Comments on FileRetrieve all comments on a file
  • Transfer OwnershipTransfer file ownership to another Google account

Why run this pair with FlowMattic

Google Sheets and Google Drive 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 of truth

Your team already edits the sheet. Folders, files and share links follow from what the rows say, and the links come back into the same rows.

Runs from your own WordPress site

The workflow runs on your server with unlimited runs, so a sheet with thousands of client rows costs the same as one with ten.

Add steps beyond Google

The same workflow can email the client their folder link, post in Slack or create a WordPress user once the folder exists.

Common questions

What does the Google Sheets and Google Drive integration do in FlowMattic?

It lets a row in a sheet create folders and files in Drive, share them, move them or export them to PDF, and it can list Drive files back into a sheet. Each step is picked on the workflow builder, so no code is needed.

Can a new file in Google Drive start a workflow?

Yes. New File, New File in Folder and Updated File are Google Drive triggers. A common use here is New File in Folder with Add New Row, which writes each new file's name and link into the sheet.

Can each client get a folder inside a main clients folder?

Yes. Use Create a Sub Folder with the ID of your main clients folder as the parent, so every new folder lands in the same place.

How do I share a file with someone outside my company?

Use Share File with their email, or Share File with Anyone to get a link that works without a Google login. Write the link into the sheet so you can send it on.

Can I copy a template document for every new row?

Yes. Copy File makes a copy of your template, Update File/Folder Name renames it after the row, and Move File puts it in the right folder.

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

Start automating Google Sheets and Google Drive

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 23 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 Drive integration 3.0.0.