Google Sheets integration stopped working
Google Sheets is the most-tickets-per-quarter receiver. “Stopped working” resolves to one of four root causes in 90%+ of cases. Work through them in order.
Cause 1 — Re-authorize
OAuth grants sometimes may expire or get revoked for some reasons. Even though the platform may still say Connected, the token may have failed silently.
- AFI > Settings > Google Sheets.
- Open the account edit popup.
- Click Update & Authorize and approve the OAuth prompt.
Cause 2 — Drive scope missing
Google requires the Google Drive API scope in addition to Sheets to list your spreadsheets. If spreadsheets don’t appear in the dropdown:
- Open Google Cloud Console, pick the project tied to AFI.
- APIs & Services > Library > enable Google Drive API if it isn’t already.
- OAuth consent screen > add the Drive scope (
https://www.googleapis.com/auth/drive) to the scopes list. - Don’t click PREPARE FOR VERIFICATION — leave the app in Testing.
- Re-authorize in AFI.
Cause 3 — Blank columns in the sheet header
The most common cause of data added to wrong column or new rows in the wrong position:
- Open the destination sheet and check row 1.
- Any empty header cell between populated headers will shift AFI’s column mapping.
- Delete the blank columns entirely (right-click column > Delete column).
Cause 4 — Permalinks must be Post name
WordPress’s default Plain permalinks break the OAuth callback for Google services.
- Settings > Permalinks.
- Pick Post name and click Save Changes.
- Re-authorize Google Sheets in AFI.
Other Sheets-specific issues
- Form entries overwriting rows — duplicate header columns. Rebuild row 1 with unique headers only.
- CF7 → Sheet with custom post type’s
post_title— use{{_post_title}}for the host page’s title, or use a[post_title]shortcode in the form for non-page CPTs. - Sheet names not showing in dropdown — update plugin, confirm Drive scope, re-authorize.