Status
Salesforce side is live as of 2026-05-05. Zapier build is pending because the Codex runtime did not expose a callable Zapier connector, even though the project credentials index notes a Zapier MCP token exists.
Live Salesforce Items
- Integration user: Google Reviews Sync, username google-reviews-sync@kylawoffice.com, user id 005UV000007isyLYAQ.
- Profile: Minimum Access - API Only Integrations.
- Permission set: Google_Reviews_Sync, id 0PSUV000000GCJl4AO.
- Permission assignment: 0PaUV00000apNXJ0A2.
- Deployed Review__c fields: Google_Review_Resource_Name__c, GBP_Location_Resource_Name__c, Google_Review_Update_Time__c.
- List view: Review__c.Unlinked_Google_Reviews, id 00BUV00000CbkJV2AZ.
- Report: Marketing Reports and Data / Unlinked Google Reviews, id 00OUV00000BuVaf2AF.
- Deploy id: 0AfUV000001Vxcj0AC. Dry-run validation id: 0AfUV000001Vxb70AC.
Local Handoff
/Users/samaguiar/Documents/Projects/Repos/sail-litify/Litify_AI_Integration_Project/handoffs/HANDOFF-google-reviews-zapier-litify-2026-05-05.md
Zapier Next Step
Create two Zaps: GBP Review -> Litify Review__c - Louisville and GBP Review -> Litify Review__c - Lexington. Trigger on Google Business Profile New Review (Instant), scoped to each location. In Salesforce, find Review__c by Google_Review_Resource_Name__c, create if missing, update only stars/comment/reviewer/update time if found and update time changed. Connect Salesforce as google-reviews-sync@kylawoffice.com, not chund+aguiar@casestatus.com.
Verification Completed
- Production deploy succeeded with RunLocalTests: 95 of 95 tests passed.
- Live metadata queried after deploy.
- Permission set object and field access queried after deploy.
- Temporary Review__c smoke insert succeeded and was deleted immediately.