User churn analysis and Automated email outreach

Name: User churn analysis and Automated email outreach
Author: Daniel Frey

186 views

by Daniel Frey

Use This Template

Workflow Steps

Scrape fivetimesfaster.com to understand the product context and value proposition.

Using: COMPOSIO

Retrieve the authenticated user's primary email address and signature to ensure the correct 'from' identity context.

Using: GMAIL

Fetch the last 100 persons from PostHog Project 56401.

Using: POSTHOG

Filter the fetched users to exclude 'Daniel Frey', 'Lara Koeman', and anyone without an email. Extract 'distinct_id' and 'email' for each valid user.

Using: LLM

Fetch raw events for each filtered user using a HogQL query. Use the 'distinct_id' from the previous step.

Using: POSTHOG

Analyze events and generate email content. Output a JSON object for each user containing 'recipient_email', 'subject', and 'html_body'. Ensure 'html_body' uses <br> for line breaks and includes the signature from Step 2.

Using: LLM

Present the generated draft summaries to the user for approval.

Using: LLM

Create Gmail drafts for each approved user. Sets 'is_html' to true and maps 'recipient_email' correctly.

Using: GMAIL

Log details of created drafts to Google Sheet.

Using: GOOGLESHEETS

About This Template

This agent is build to automate you outreach using data from your analytics provider (user interactions, page views, pipelines, etc).

How to Use This Template

Click "Use This Template" to open the template in your workspace
Our AI will ask you questions to customize the workflow for your needs
Connect the required integrations ()
Review and activate your customized workflow

Created by

Daniel Frey

Template Creator

Ready to automate?

Use This Template

User churn analysis and Automated email outreach

Workflow Steps

About This Template

How to Use This Template

Created by

Ready to automate?

Product

Company

Legal

Hey there!