Automated customer testimonial outreach from Google Sheets to Webflow

• Automate outreach for customer testimonials based on NPS scores.
• Generate personalized emails using AI for customer engagement.
• Streamline testimonial submissions and notifications for team awareness.

Triggers daily at 09:00 UTC to load NPS data from Google Sheets. Filters promoters based on NPS scores and drafts outreach emails using GPT-4. Parses email responses and normalizes the submission data. Publishes testimonials to Webflow and sends notifications via Slack.

1. 1
   Import the workflow template into n8n.
2. 2
   Configure Google Sheets credentials and specify the sheet ID.
3. 3
   Set up OpenAI credentials for email drafting.
4. 4
   Configure SMTP settings for sending outreach emails.
5. 5
   Set up Webflow credentials for publishing testimonials.
6. 6
   Deploy the workflow and monitor for daily execution.