Table of Contents
Overview #
The Ultra Addons Google Sheets Addon for WPForms allows you to automatically send form submissions to Google Sheets in real time. This integration eliminates manual data entry, keeps records organized, and makes collaboration easier by storing submission data in a shared spreadsheet.
🛠️ Getting Started #
1. Install & Activate the Addon #
- Go to Plugins → Add New in your WordPress dashboard.
- Upload the Ultra Addons Google Sheets Addon ZIP file.
- Click Install, then Activate.
2. Connect Your Google Account #
- Navigate to WPForms → Settings → Integrations.
- Find Google Sheets in the integrations list.
- Click Connect and log in with your Google account.
- Grant permission so the addon can access your spreadsheets.
3. Create or Select a Google Sheet #
Before setting up the integration:
- Use an existing Google Sheet, or
- Create a new one specifically for your form entries.
Make sure each column has a clear header (e.g., Name, Email, Message).
4. Enable Google Sheets for a WPForm #
- Go to WPForms → All Forms and open the form you want to connect.
- Click Settings → Google Sheets.
- Enable the integration by toggling “Enable Google Sheets”.
- Select:
- Your Google Sheet
- Sheet tab
- Row insertion method (top or bottom)
5. Map Your Form Fields #
In the field mapping section:
- Choose a sheet column
- Assign the corresponding WPForms field
- Repeat for all fields you want saved
The addon will automatically format and structure the data.
6. Save & Test the Integration #
- Save your form settings.
- Submit a test form from the frontend.
- Open your Google Sheet to confirm the data appears correctly.
If the test entry is added, the integration is fully active.
Troubleshooting #
Data is not appearing in the Google Sheet #
- Ensure Google API connection is active.
- Reconnect your Google account if needed.
- Check that sheet column headers are not empty.
- Verify field mapping.
Need Help? # #
If you’re a Free User, please open a support ticket here
