How it works
To get pachca notifications in Google Sheets, you don't need a developer: a ready-made scenario watches events and sends messages for you.
- Starts when: Schedule Trigger
- Then: Get Contracts
- Check: Loop Over Contracts
- Then: Calculate Deadline Status
- Check: IF Approaching Deadline
- If yes: Send Reminder (Slack)
- Check: IF Deadline Passed
- If yes: Get Influencer Posts
- Then: Check Post Compliance (Claude AI)
- Check: IF Breach Detected
- If yes: Notify Breach (Slack)
- If yes: Log Breach
- If yes: Respond to Webhook
- If no: End (Compliant Path)
- Starts when: Webhook
You can launch this pachca + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.