Choose one destination or route data across feeds

WPForms Google Sheet Connector Pro sends submissions from WordPress sites using WPForms Lite or WPForms Pro to connected Google Sheets. New entries can sync as they arrive, so teams can review submissions in a shared spreadsheet without manual exports, CSV downloads, copying and pasting, or custom coding.

Feeds define where each form sends its data. You can connect multiple forms, create multiple feeds for a form, and direct a form to multiple Google Sheets. A feed can use a separate spreadsheet or a different tab in the same spreadsheet, which lets teams keep destinations separate when their processes call for it.

Map form fields to sheet columns

Choose which form values go into which columns, then reorder or rename the sheet headers. WPForms Smart Tags can also be used as column headers. The free version provides date-column functionality; Pro supports additional Smart Tags and advanced syncing settings.

Sync new submissions or earlier entries

New submissions can transfer automatically, while Pro also supports syncing existing WPForms entries to Google Sheets. Submission date and time can be included. Date-based syncing and filters let you control which records move to a sheet, including by a selected date range or conditions relevant to a process.

Connect with OAuth or a Service Account

In the integration options, connect a Google account through OAuth or configure the available Service Account option. Grant the required Google Drive and Google Sheets permissions. If authentication needs renewal, check those permissions. Data transfers between the WordPress website and the connected Google account. GSheetConnector states that it does not store form entries on third-party servers.

Format rows and troubleshoot the connection

Formatting controls can freeze the header row and apply colors to the header, odd rows, and even rows. A debug log and system-status information are available for troubleshooting connection or synchronization issues. Teams can use the resulting sheets to follow up on leads, share submissions, prepare reports or dashboards, and collaborate on form data.

Set up the feed and review a test entry

1. Install and activate the Pro add-on on a WordPress website that uses WPForms Lite or WPForms Pro.
2. Open the Google Sheets integration settings, connect an account with OAuth or configure the Service Account option, and grant the required Google Drive and Google Sheets permissions.
3. Create a feed, select the form and destination sheet, then set field mappings, headers, filters, or formatting options before saving.
4. Submit a test entry and check the synchronized row in Google Sheets.