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

Connect Crove and Google Sheets

Crove fills smart templates to make contracts, offer letters and certificates. Google Sheets is often where the names, prices and dates already live. FlowMattic connects the two from your WordPress site: each row can produce a document, and each finished document can be logged with its PDF link. Useful for HR teams, agencies and course providers.

9 triggers 34 actions 6 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Crove3 triggers

Do this in Google Sheets19 actions

1. TriggerDocument Created
2. ActionAdd New Row

When Crove fires Document Created, 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

Crove 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.

Crove app icon Google Sheets app icon Ready-made template

Log each new Crove document and email the PDF link

When a document is created, its name, respondent and PDF link go into a row, and Email (SMTP) sends the link to the person who filled it in.

Document CreatedAdd New RowEmail (SMTP)

View the template
Crove app icon Google Sheets app icon

Generate a PDF from a template for each new row

Add a row with a name, course and date, and Generate PDF From Template fills your certificate or letter template. Update Row writes the PDF link back next to the data.

New Spreadsheet RowGenerate PDF From TemplateUpdate Row

Crove app icon Google Sheets app icon

Send a contract for completion from a sheet row

Create Document starts a contract with the client details from the row, and Create Email Invitation asks the client to fill in and finish it, so sales staff only update the sheet.

New Spreadsheet RowCreate DocumentCreate Email Invitation

Crove app icon Google Sheets app icon

Mark the row when a document is completed

When the respondent finishes, find the row by document ID and set its status to Completed with the final PDF, so the tracker shows which contracts are done.

Document CompletedGenerate PDF of DocumentLookup Row DataUpdate Row

Crove app icon Google Sheets app icon

Collect submitted document answers into a sheet

Get Document Details reads the responses of each submitted document, such as start date or salary, and Add New Row records them for reporting without opening each file.

Document SubmittedGet Document DetailsAdd New Row

Crove app icon Google Sheets app icon

Create Word copies for rows marked for editing

When the status column changes to Needs edits, Export document as docx gives a Word file the legal team can mark up, and its link goes back into the row.

Update Specific Column ValueExport document as docxUpdate Row

Set up: log new documents

At the end, every new Crove document is logged in your sheet with its PDF link, and the respondent gets the link by email.

  1. Prepare the tracker

    Create a sheet with headers such as Document ID, Template, Respondent, Email, PDF link and Status.

  2. Connect Crove and Google Sheets

    Under Connects, add your Crove account and a Google account that can edit the spreadsheet.

  3. Start with Document Created

    Create a workflow with the Crove Document Created trigger and create a test document so its fields are captured.

  4. Add the row

    Add Google Sheets Add New Row, map the document ID, template name, respondent and PDF link, and test the step.

  5. Email the link

    Add Email (SMTP), send the PDF link to the respondent's email, test and switch the workflow on.

Import the ready-made template Intermediate, about 5 min to set up
Log each new Crove document and email the PDF link Template
  1. Crove app icon 1. Trigger in Crove Document Created
  2. Google Sheets app icon 2. Action in Google Sheets Add New Row

    Fields mapped from the earlier steps (a typical setup)

    From CroveTo Google Sheets
    Document IDDocument ID
    Template nameTemplate
    Respondent nameRespondent
    Respondent emailEmail
    PDF URLPDF link
  3. 3. FlowMattic tool Email (SMTP)
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

  • Template variables in Crove must match what you map from the sheet. Keep column headers close to the variable names and test with one row first.
  • A new-row workflow makes one document per row. Pasting a hundred rows creates a hundred documents, so add a Filter on a Ready column if that is not what you want.
  • Store the Crove document ID in the sheet. The completed and edit examples need it to find the right row later.

Triggers (3)

  • Document CreatedTriggers when a new document is created
  • Document CompletedTriggers when a document is completed
  • Document SubmittedTriggers when a document is submitted

Actions (15)

  • Get Template ListGet the list of all available templates in your Crove account
  • Get Template DetailsGet the details of a template by template ID
  • Create TemplateCreate a new template from another template
  • Get Documents ListGet the list of all available documents in your Crove account
  • Get Document DetailsGet details of a particular document by its ID
  • Create DocumentCreate a new document based on template
  • Complete DocumentMark the document as completed
  • Generate PDF of DocumentGenerate a PDF of the document and get the PDF URL
  • Get Document Respondents ListGet the list of all responders to a document
  • Create Invitation LinkCreate invitation link to fill or sign the document
  • Get Email Invities ListGet list of all the email invities of a document
  • Create Email InvitationSend email invitation link to fill & sign the document
  • Generate PDF From TemplateGenerate PDF of a document created from the template
  • Export document as docxExport the completed document as DOCX format
  • Update Document ResponseUpdate the incomplete document response with new data
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

Why run this pair with FlowMattic

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

Paperwork from the data you have

Names, prices and dates already in the sheet fill the template, so nobody retypes them into each contract or certificate.

Bulk runs at no extra cost

Runs are unlimited, so issuing certificates for a whole cohort needs no bigger FlowMattic plan.

Documents logged on your side

Each document's details pass through your own WordPress site into a sheet you control, giving you a record outside Crove.

Common questions

Can I create Crove documents in bulk from Google Sheets?

Yes. Each new row runs Generate PDF From Template or Create Document with that row's values. For a sheet that already has rows, a Schedule with Get Rows and an Iterator can work through them once.

Where does the PDF link end up?

Wherever you map it. The examples write it into the row with Update Row or Add New Row, and the first one also emails it with Email (SMTP).

Can the client fill in part of the document?

Yes. Create Document with the values you know, then Create Email Invitation or Create Invitation Link so the client completes the rest in Crove.

What starts a workflow on the Crove side?

Document Created, Document Completed and Document Submitted. Each can add or update a row in your sheet.

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

Start automating Crove and Google Sheets

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. Crove integration 1.1.0, Google Sheets integration 2.2.4.