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 triggers47 actions6 example workflows10 ready-made templatesUnlimited 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.
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 Row→Create a Folder→Share Folder→Update Row
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 Row→Create File From Text→Share File
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.
Schedule→Get Row Data→AI Agent→Create File From Text
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 Value→Find File→Move File
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 Value→Export File to PDF→Share File with Anyone→Update Cell Data
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.
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. Trigger in Google Sheets
New Spreadsheet Row
2. Action in Google Drive
Create a Folder
3. Action in Google Drive
Share Folder
4. Action in Google Sheets
Update Row
Fields mapped from the earlier steps (a typical setup)
From Google Sheets
To Google Sheets
Client name
Folder name
Client email
Share with email
Folder ID
Folder to share
Folder link
Folder 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.
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.
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.