Send Workflow Data to Google Sheets

The plugin registers Google Sheets actions for spreadsheet, worksheet, and row operations. These actions use a saved Google OAuth 2 connection. You provide the spreadsheet ID and sheet tab or other action-specific values; the inspected builder does not make a universal spreadsheet-and-worksheet picker available for every action.

Prepare Google OAuth

Create OAuth client credentials in Google Cloud Console using a Web application client.

Enable the Google Sheets API and Google Drive API for that project.

Open Agent Workflows → Connections → Add New. Set the Integration identifier to google_sheets, enter a label, and choose OAuth 2.

Copy the displayed Callback URL into the Google OAuth client’s authorized redirect URIs. Enter the Client ID and Client Secret, then save the connection.

Edit the saved connection and click Connect with Google. Complete Google’s authorization flow and return to WordPress.

Screenshot to add: Google OAuth connection form with Callback URL and Connect with Google

Choose a Google Sheets action

The built-in action catalog includes Google Sheets Create Spreadsheet, Google Sheets Find Spreadsheets, Google Sheets Delete Spreadsheet, Google Sheets Create Sheet, Google Sheets Find Sheet, Google Sheets Copy Sheet, Google Sheets Delete Sheet, Google Sheets Clear Sheet, Google Sheets Export Sheet, Google Sheets Add Row, Google Sheets Append Row (legacy), Google Sheets Update Row, Google Sheets Append or Update Row, Google Sheets Get Row, Google Sheets Get All Rows, Google Sheets Delete Row, and Google Sheets Create Column.

For new row-insertion workflows, prefer Google Sheets Add Row. The legacy Google Sheets Append Row action remains registered for backward compatibility.

Configure a row action

Google connection: Select the saved Google OAuth connection.

Spreadsheet ID (from the sheet URL): Enter the ID from the Google Sheets URL.

Sheet tab name: Enter the worksheet tab name. The default is Sheet1.

Row values, comma-separated (supports {{trigger.fields.*}}): Supply values in the order they should be written. Use the supported trigger-field tokens when mapping submission data.

Some actions expose extra fields, such as Row number (1-based), Target range (optional, e.g. A5:E5), or Column to match on (letter or index, e.g. A or 0). Use the fields shown for the selected action.

Screenshot to add: Google Sheets Add Row configuration with connection, spreadsheet ID, sheet tab, and row values

Review results and protect spreadsheet data

Google Sheets actions return a success flag and response data; row-write actions can include an updated range when the API returns one. A successful node result is evidence of the API response, not a separate manual confirmation that every expected cell is correct. Inspect the action output and verify the target sheet during testing.

Use a test spreadsheet first, map only necessary fields, and avoid sending sensitive customer information to a sheet unless its access permissions and retention are appropriate.