Perfex CRM and Google Sheets automations
Perfex CRM issues the invoices and Google Sheets tracks them, so “New Invoice” runs “Add New Row to Sheet”.
Set up an automation: when new invoice in Perfex CRM, add new row to sheet in Google Sheets
Build itOr have an AI agent work across Perfex CRM and Google Sheets: it decides what to do in each on every run, on a schedule or when you ask it in its chat.
Perfex CRM and Google Sheets in practice
Used for
Perfex CRM issues the invoices and Google Sheets tracks them, so “New Invoice” runs “Add New Row to Sheet”.
Best template
“New Invoice” in Perfex CRM, then “Add New Row to Sheet” in Google Sheets. Each new invoice lands as a row, giving you a running list you can sort and total.
Watch out
A short delay before the row appears is normal, because “New Invoice” in Perfex CRM checks on a schedule.
Perfex CRM and Google Sheets templates
Pick one and Captain builds it with you.


When new invoice in Perfex CRM, add new row to sheet in Google Sheets
Build this

When new project in Perfex CRM, add new row to sheet in Google Sheets
Build this

When new task in Perfex CRM, add new row to sheet in Google Sheets
Build this
Perfex CRM and Google Sheets triggers and actions
Every one of both apps. A trigger starts the work; actions are the steps.
Triggers
9- New contractTriggers when a new contract is created
- New customerTriggers when a new customer is added
- New leadTriggers when a new lead is created
- New projectTriggers when a new project is created
- New taskTriggers when a new task is created
- New ticketTriggers when a new ticket is created
- New proposalTriggers when a new proposal is created
- New estimateTriggers when a new estimate is created
- New invoiceTriggers when a new invoice is created
No triggers match.
Actions
9- Create leadCreates a new lead
- Create contractCreates a contract in the system
- Create customerCreates a new customer
- Create estimateCreates a estimate in the system
- Create projectCreates a project in the system
- Create proposalCreates a new proposal in the system
- Create taskCreates a new task in the system
- Create ticketCreates a ticket in the system
- Create timesheetCreates a timesheet in the system
No actions match.
Triggers
1- Row added or updatedRuns when row added or updated
No triggers match.
Actions
23- Update spreadsheet rowUpdate columns in sheet row
- List rows in sheetGet rows from a sheet tab as objects with row numbers. Supports an optional header row, offset/limit paging, and fetching from the last row.
- Delete rowsDelete one or more rows from a specific sheet in a Google Spreadsheet using a row range or row numbers.
- Add new row to sheetRuns as a step in Google Sheets.
- Lookup spreadsheet rowsFind rows in a Google Sheet that match a column value or an advanced filter.
- Copy sheet to spreadsheetCopy a sheet to another file
- Add multiple rowsAdd one or more rows to a specific sheet in a Google Spreadsheet. Provide data column-by-column or paste a JSON array for bulk inserts. If the sheet has no headers, they will be auto-created from your JSON keys.
- Create subsheetAdd a new subsheet to a spreadsheet and optionally set its position and add column headers in the first row.
- Create sheet columnInsert a new column into the specified Google Sheets sheet at the given index (or append to the end) and optionally set its header.
- Get rows from rangeRetrieve rows from sheet range
- Create a spreadsheetCreate a new spreadsheet.
- Find subsheetSearches a sheet in a spreadsheet by name and returns the sheet name, column titles, and number of rows.
- Get row detailsRetrieve values and metadata for a specific row in a spreadsheet sheet.
- Clear spreadsheet rowClears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.
- Create spreadsheet from templateCreate sheet from template
- List spreadsheetsFetch all spreadsheets
- List spreadsheet tabsLists all tabs (sheets) in a spreadsheet and returns the total count.
- Batch update cell valuesUpdate multiple cells at once
- Format spreadsheet rowFormat row font and background
- Add conditional formatting ruleApply conditional formatting to cells in a Google Sheets spreadsheet based on their values
- Update sheet nameRenames an existing sheet (tab) within a Google Spreadsheet to a new name you specify.
- Update multiple rowsUpdate values in one or more rows of a Google Sheet.
- Permanently delete spreadsheetPermanently delete a spreadsheet from Google Drive, including files on shared drives.
No actions match.
Questions about Perfex CRM and Google Sheets
What can start a Perfex CRM and Google Sheets automation?
“New invoice”, “New project” and “New task”.
Which other apps work with both Perfex CRM and Google Sheets?
Slack, Shopify, Todoist, Google Calendar and Zoho CRM. Each one has templates with Perfex CRM and with Google Sheets, so a third app can join the same job.
All Perfex CRM integrations · All Google Sheets integrations · Every app, A to Z
Connect Perfex CRM and Google Sheets
Or pick another template above. Free to start.
Build it with Captain