Summary

Louisville Google Business Profile review ingestion into Litify is live through Zapier for future reviews. The historical backfill needs a reconciliation pass because legacy Litify Review__c rows do not have Google resource ids yet.

Live Counts

• Google Review__c rows in Litify: 1,090.
• Louisville: 911.
• Lexington: 179.
• Rows with Google_Review_Resource_Name__c: 1.
• Rows missing Google_Review_Resource_Name__c: 1,089.

Backfill Work Staged

• Local runner: /Users/samaguiar/Documents/Projects/Repos/sail-litify/Litify_AI_Integration_Project/scripts/google_reviews_backfill.py
• Handoff: /Users/samaguiar/Documents/Projects/Repos/sail-litify/Litify_AI_Integration_Project/handoffs/HANDOFF-google-reviews-zapier-litify-2026-05-05.md
• The runner writes dry-run CSVs for matched updates, missing creates, ambiguous matches, and duplicate existing-resource rows before any live write.

Current Block

• OAuth consent for business.manage succeeded.
• Temporary quota project sail-gbp-backfill-202605042126 was created.
• Direct reviews.list remains blocked because mybusiness.googleapis.com is gated/disabled and Google denies enabling it without Google Business Profile API project approval.
• Zapier can read GBP because Zapier's Google-approved app is already connected.

Next Actions

1. Check Zapier Transfer/Replay for the GBP New Review trigger.
2. If Zapier Transfer cannot pull historical reviews, get a CSV/export from a Google-approved reviews platform or request GBP API project approval.