ARPHost CF7 Submission Archive captures every Contact Form 7 submission and:<\/p>\n\n
No Google API keys, OAuth, or service accounts required \u2014 the Sheets integration uses a free Google Apps Script Web App you deploy in about two minutes (companion script included in IP address and user-agent storage are off by default<\/strong>. Enable them in Settings only if your privacy policy covers it.<\/p>\n\n This plugin connects to Google services to forward Contact Form 7 submissions to a Google Sheet. Both connections are off by default<\/strong> (Settings \u2192 Send to Google Sheets<\/em>) and use your own<\/em> Google account\/spreadsheet \u2014 no data passes through any ARPHost server.<\/p>\n\n When Delivery method<\/em> is set to Google Sheets API<\/em>, the plugin sends a submission's mapped field values directly to the Google Sheets API ( When Delivery method<\/em> is set to Webhook<\/em>, the same submission payload (JSON) is POSTed instead to a Google Apps Script Web App URL that you deploy yourself from That's it. Each form gets its own tab automatically. Use Per-form routing<\/em> to rename tabs or send a form to a different spreadsheet ( Optionally add a field mapping so your CF7 field names become friendlier payload keys. Matching is forgiving: case-insensitive, and spaces\/underscores count as hyphens \u2014 so First Name=firstName\nLast Name=lastName\nyour-email=email\nVolunteer=volunteers\nYard Sign=yardSign<\/p><\/li>\n<\/ol>\n\n The left side must still correspond to the CF7 field name<\/em> (the name inside the form tag, e.g. Checkbox fields with multiple selections are sent as JSON arrays; single-value fields are sent as plain strings.<\/p>\n\n Nothing special is required. Every payload carries Yes. Capture hooks All CF7 forms. Use the Only the posted field values are stored; uploaded files are handled by CF7 as usual and are not copied.<\/p><\/dd>\n\n<\/dl>\n\n\ngoogle-apps-script-example.js<\/code>).<\/p>\n\nPrivacy<\/h4>\n\n
Developer hooks<\/h4>\n\n
\n
cf7dbgs_capture_submission<\/code> \u2014 filter; return false to skip capturing a submission<\/li>\ncf7dbgs_store_fields<\/code> \u2014 filter fields before DB storage<\/li>\ncf7dbgs_webhook_payload<\/code> \u2014 filter the JSON payload sent to the webhook<\/li>\ncf7dbgs_webhook_args<\/code> \u2014 filter wp_remote_post args<\/li>\ncf7dbgs_after_store<\/code> \u2014 action fired after a row is stored<\/li>\n<\/ul>\n\nExternal services<\/h3>\n\n
Google Sheets API (recommended mode)<\/h4>\n\n
sheets.googleapis.com<\/code>) using a Google Cloud service account you create and paste into Settings. Before that, it exchanges the service account's key for a short-lived OAuth2 access token via Google's token endpoint (oauth2.googleapis.com<\/code>).<\/p>\n\n\n
formTitle<\/code>\/formId<\/code>), sent as a new row appended to the spreadsheet\/tab you configured. Anti-spam\/captcha tokens (reCAPTCHA, hCaptcha, Turnstile) are stripped before sending. For authentication, a signed JWT derived from your own service-account credentials is sent to obtain the access token \u2014 no data is sent to any third party you did not configure.<\/li>\nGoogle Apps Script webhook (alternate mode)<\/h4>\n\n
google-apps-script-example.js<\/code> (bundled with this plugin). That script runs on Google's infrastructure (script.google.com<\/code> \/ script.googleusercontent.com<\/code>) under your own Google account and appends the row to your sheet.<\/p>\n\n\n
formTitle<\/code>\/formId<\/code> plus form fields, captcha tokens stripped), sent as the POST body.<\/li>\n\n
arphost-cf7-submission-archive<\/code> folder to \/wp-content\/plugins\/<\/code>, or install the zip via Plugins \u2192 Add New \u2192 Upload.<\/li>\nGoogle Sheets setup \u2014 API mode, no Apps Script (recommended)<\/h4>\n\n
\n
Form Title=Tab<\/code> or Form Title=SPREADSHEET_ID!Tab<\/code>).<\/p>\n\nGoogle Sheets setup \u2014 webhook mode (Apps Script)<\/h4>\n\n
\n
Submissions<\/code>.<\/li>\ngoogle-apps-script-example.js<\/code> (bundled with this plugin). Set your SHEET_ID<\/code>.<\/li>\nFirst Name<\/code> matches the CF7 field first-name<\/code>:<\/p>\n\n[email* your-email]<\/code> is your-email<\/code>), not the visible label.<\/p>\n\nAdding a new form later<\/h4>\n\n
formTitle<\/code>\/formId<\/code>, and the companion Apps Script creates a new sheet tab (named after the form) with columns built from the fields automatically. Optionally add field-map lines if you want friendlier payload keys \u2014 the Settings page lists each form's detected fields.<\/p>\n\n\n\n
Does it capture submissions if the email fails to send?<\/h3><\/dt>\n
wpcf7_before_send_mail<\/code>, so the submission is saved even if SMTP delivery fails.<\/p><\/dd>\nWhich forms are captured?<\/h3><\/dt>\n
cf7dbgs_capture_submission<\/code> filter to exclude specific forms.<\/p><\/dd>\nAre file uploads stored?<\/h3><\/dt>\n
1.2.2<\/h4>\n\n
\n
1.2.1<\/h4>\n\n
\n
<script><\/code> tag (admin\/class-cf7dbgs-admin.php) into admin\/js\/cf7dbgs-field-mapping.js<\/code>, enqueued via wp_enqueue_script()<\/code> on the Settings page only. No functional change.<\/li>\n1.2.0<\/h4>\n\n
\n
arphost-cf7-submission-archive<\/code>, text domain to match) per WordPress.org plugin review feedback \u2014 the prior name\/slug led with the Contact Form 7 (\"CF7\") trademark and was too close to other CF7\/Sheets integration plugin names. No functional changes. Contributors line corrected to the actual WordPress.org account (hostalot<\/code>). Added the Requires Plugins: contact-form-7<\/code> header.<\/li>\n<\/ul>\n\n1.1.9<\/h4>\n\n
\n
cf7-database-google-sheets<\/code> \u2014 this is the canonical slug going forward (matches the plugin's readable name and is what WordPress Playground \/ Plugin Check expects). The plugin's packaged folder and zip are now also named cf7-database-google-sheets<\/code> to match, so the slug is consistent everywhere. The GitLab project\/repo itself stays named cf7-db-gsheets<\/code> \u2014 only the WordPress-facing plugin slug changed.<\/li>\n<\/ul>\n\n1.1.8<\/h4>\n\n
\n
cf7-db-gsheets<\/code> (matches the actual plugin slug at the time) \u2014 resolved Plugin Check errors on dev.arphost.com, but broke it on WordPress Playground\/Plugin Check (which expects cf7-database-google-sheets<\/code>). Superseded by 1.1.9.<\/li>\n<\/ul>\n\n1.1.7<\/h4>\n\n
\n
1.1.6<\/h4>\n\n
\n
1.1.5<\/h4>\n\n
\n
1.1.4<\/h4>\n\n
\n
1.1.3<\/h4>\n\n
\n
1.1.2<\/h4>\n\n
\n
1.1.1<\/h4>\n\n
\n
1.1.0<\/h4>\n\n
\n
1.0.8<\/h4>\n\n
\n
1.0.7<\/h4>\n\n
\n
1.0.6<\/h4>\n\n
\n
1.0.5<\/h4>\n\n
\n
1.0.4<\/h4>\n\n
\n
1.0.3<\/h4>\n\n
\n
1.0.2<\/h4>\n\n
\n
1.0.1<\/h4>\n\n
\n
{\"success\":false}<\/code> in the body are now correctly recorded as failed (previously marked \"sent\").<\/li>\n1.0.0<\/h4>\n\n
\n