Question 1

Gmail not receiving emails

Accepted Answer

Why it happens: Full Google account storage (15GB/pooled cap reached), incorrectly configured MX records in your domain DNS, accidental filter rule routing mail to Trash/Archive, or strict spam filters. Solution steps: Check storage usage at one.google.com/storage. If storage is 100% full, Google blocks all inbound messages immediately. Search in "All Mail", "Spam", and "Trash" using the query: `in:anywhere from:sender@domain.com`. If using a custom Workspace domain, verify DNS MX records using Google Workspace Admin Toolbox MX Check. Review Settings > Filters and Blocked Addresses to verify no rule has "Skip Inbox (Archive it)" or "Delete it" active. Prevention: Configure automated storage cleanups, set up domain SPF/DKIM/DMARC records properly, and review active email filters quarterly.

Question 2

Google Drive not syncing on Desktop

Accepted Answer

Why it happens: Google Drive desktop client authentication token expired, firewall/VPN blocking Google Cloud backend sockets, or corrupt local database cache in DriveFS. Solution steps: Click the Google Drive tray icon > Settings (gear icon) > Pause Syncing, wait 10 seconds, then click Resume Syncing. Check if your proxy, antivirus, or corporate VPN is blocking `*.google.com` sync endpoints. Disconnect account from Google Drive app Preferences and sign back in with your Google Workspace credentials. For Windows: Terminate Google Drive in Task Manager, clear `%LocalAppData%\Google\DriveFS`, and restart the app. Prevention: Ensure desktop client is updated to the latest build and avoid nesting symlinks inside Google Drive mirrors.

Question 3

Google Sheets formula not working (#REF!, #VALUE!, #N/A)

Accepted Answer

Why it happens: Circular dependency (#REF!), mismatched data types like text versus numbers (#VALUE!), missing lookup key (#N/A), or locale syntax discrepancy (comma `,` vs semicolon `;`). Solution steps: Hover over the error cell to inspect the tooltip diagnostic note. For #REF! errors with ARRAYFORMULA or FILTER, clear the empty rows below the formula cell to remove cell overwrite collisions. For #N/A in VLOOKUP/XLOOKUP, wrap with `=IFERROR(your_formula, "Not Found")` or trim leading spaces using `=TRIM()`. Check File > Settings > Locale. European locales require semicolons `;` as parameter separators instead of commas `,`. Prevention: Use structured table ranges, sanitize source data with TRIM and VALUE functions, and validate input headers.

Question 4

Google Docs not opening or stuck on loading screen

Accepted Answer

Why it happens: Ad-blocker or browser extension interfering with Google Docs WebSocket connections, corrupt browser cache, or temporary Workspace outage. Solution steps: Open the document in an Incognito / Private browsing window to isolate extension conflicts. Disable aggressive ad blockers or grammar extensions on `docs.google.com`. Clear browser cached images and cookies for the past 24 hours in Chrome Settings. Check Google Workspace Status Dashboard (workspace.google.com/status) for ongoing service disruptions. Prevention: Keep browser extensions minimal and maintain secondary browser profiles for enterprise documents.

Question 5

Google account storage full (15GB limit hit)

Accepted Answer

Why it happens: Accumulated uncompressed 4K video backups in Google Photos, orphaned Drive files, shared folders taking quota, or hundreds of high-res email attachments. Solution steps: Navigate to one.google.com/storage/management to inspect largest files across Drive, Gmail, and Photos. In Gmail, search `has:attachment larger:10M` and delete obsolete heavy newsletters and zip files. Empty the Google Drive Trash permanently (items in Trash still consume quota for up to 30 days). In Google Photos, convert original quality backups to Storage Saver mode to reclaim up to 60% disk space. Prevention: Set up Google Takeout archives annually and store bulk backups on external hard drives or Google Cloud Coldline storage.

Question 6

Google Forms responses not appearing in Google Sheets

Accepted Answer

Why it happens: The link between Google Form and destination Sheet was severed, column structure was altered, or sheet tab was renamed/deleted. Solution steps: Open the Form in edit mode, switch to the "Responses" tab, and click the 3 dots menu > "Select destination for responses". Click "Unlink form", refresh the page, and select "Link to existing spreadsheet" or "Create a new spreadsheet". Check if the form has reached response collection limits in Form settings. Never rename or delete the automatically generated timestamp column in the linked response sheet tab. Prevention: Create a secondary calculation tab using `=QUERY('Form Responses 1'!A:Z, ...)` instead of modifying raw form response tabs directly.

Question 7

Google Calendar not syncing on Mobile / Outlook

Accepted Answer

Why it happens: Mobile background data restricted, Calendar app sync toggles disabled in Google account settings, or corrupt calendar sync cache. Solution steps: On Android/iOS: Go to Settings > Accounts > Google > Account Sync and verify "Calendar" toggle is enabled. In Android Settings > Apps > Calendar > Storage > Clear Cache (do not clear data unless backed up). Verify Date & Time on your device is set to "Automatic / Network Provided" — clock drift breaks OAuth authentication. Open calendar.google.com on desktop to confirm if the event exists on Google servers. Prevention: Always create events in the primary Google account calendar rather than local device phone storage.

Question 8

Apps Script authorization error ("Script function not found" or "Authorization required")

Accepted Answer

Why it happens: Google OAuth scopes changed after script edit, multiple Google accounts signed into same browser session, or third-party add-on policy restrictions. Solution steps: Sign into Chrome using a single Google profile instead of multiple accounts in the same window (multi-login breaks Apps Script auth tokens). Open Apps Script editor > Run any simple test function > Click "Review Permissions" > "Advanced" > "Go to script (unsafe)" and grant access. In `appsscript.json` manifest, verify that `oauthScopes` includes required endpoints like `spreadsheets` or `gmail.send`. Ensure the function name specified in your custom menu trigger matches the exact function signature in your `.gs` file. Prevention: Isolate development accounts using dedicated Chrome Personas and specify explicit minimal scopes in manifest.

Question 9

Apps Script quota error ("Service invoked too many times" / "Exceeded maximum execution time")

Accepted Answer

Why it happens: Free consumer Gmail accounts have a 6-minute single execution limit and 100 email/day quota; Workspace accounts have 30-minute limit and 1,500 email/day quota. Solution steps: Batch spreadsheet read/write operations using `getValues()` and `setValues()` once instead of calling `getValue()` inside a loop. For scripts processing large datasets, implement execution time checkpoints (`Date.now() - startTime > 300000`) and trigger continuation with time triggers. Use `Utilities.sleep()` sparingly; prefer asynchronous Webhooks or Cloud Tasks for heavy processing. Upgrade from free `@gmail.com` to Google Workspace Business Starter for 15x higher email quotas. Prevention: Profile Apps Script execution times using console benchmarks and optimize bulk API calls.

Question 10

Google Analytics 4 (GA4) data missing or showing 0 users

Accepted Answer

Why it happens: Measurement ID (`G-XXXXXXXXXX`) missing or misconfigured, Consent Mode blocking tags without user opt-in, or GA4 24-48 hour reporting lag. Solution steps: Open GA4 Realtime Overview (`Reports > Realtime`) and navigate your website in another tab — standard reports take 24 to 48 hours to process data. Inspect your website source code or Google Tag Assistant (tagassistant.google.com) to verify tag firing. Check if cookie consent banners (GDPR) are preventing `analytics_storage` from granting consent before tracking executes. Confirm Measurement ID in Google Tag Manager matches the Stream ID in GA4 Admin > Data Streams. Prevention: Test all tracking deployments using Google Tag Assistant Preview mode and verify debugger events in GA4 DebugView.

Question 11

Google Ads conversion tracking status: "Unverified" or "No recent conversions"

Accepted Answer

Why it happens: Conversion tag not installed on the actual thank-you page, enhanced conversions user data hash missing, or no paid ad clicks generated yet. Solution steps: Install Google Tag Assistant extension and perform a test conversion purchase or form submission. Check Google Ads > Goals > Conversions. If status is "Unverified", the tag has never registered an event in 30 days. Ensure conversion action ID and Conversion Label match exactly in Google Tag Manager. Verify that cross-domain tracking or redirect parameters (`gclid` / `wbraid` / `gbraid`) are not stripped by web server redirects. Prevention: Enable Enhanced Conversions in Google Ads and set up Server-Side GTM for resilient conversion measurement.

Question 12

Looker Studio data source error ("System Error" or "Config error")

Accepted Answer

Why it happens: Underlying Google Sheet column headers were renamed or deleted, BigQuery dataset permissions revoked, or field data types changed. Solution steps: In Looker Studio edit mode, click Resource > Manage added data sources > Edit > "Reconnect". Review any newly added or missing fields indicated in blue/red in the field mapping pane. Verify the Google account viewing the dashboard has "Viewer" or "Editor" permissions on the underlying Google Drive / BigQuery source. For community connectors, refresh OAuth credentials in Account Data Credentials settings. Prevention: Maintain frozen header names in source Google Sheets and build reports on dedicated database views rather than production tables.

Fix Common Google Problems