Yeray Fraga

Magic Yeray Fraga

Exploring the art of automation and AI-powered creativity.

Discover The Magic

Full Interview

Full Interview

Amazing Song

Amazing Song

Speaker Introduction

Speaker Introduction

Interview Highlights

Interview Highlights

Automation Workflows

Data Analysis Automation

1
HTTP Request (Trigger)
2
Google Drive (Get Document)
3
OpenAI (ChatGPT)
4
Google Sheets (Append Row)
5
Email (Send)
6
Error Handling (Webhook Response)
7
Quality Control (Data Validation)
8
Formatting (Format Table)
9
Notification (Slack)
10
Log (Write)

Automatically analyze documents stored in Google Drive, summarize key points using ChatGPT, and append results to a Google Sheet. Then, notify stakeholders through email and Slack.

Pain Points Alleviated: Reduces time spent on manual document review and sharing of insights, enhances collaboration, and ensures data accuracy.

Sales Prospecting Automation

1
Cron Job (Trigger)
2
LinkedIn (Search Contacts)
3
OpenAI (ChatGPT)
4
Google Sheets (Create Spreadsheet)
5
Email (Send Lead Report)
6
Quality Control (Data Validation)
7
Error Handling (Webhook Response)
8
Formatting (Format for Clarity)
9
SMS (Send Reminder)
10
Log (Write)

Automatically search for potential leads on LinkedIn, summarize relevant information using ChatGPT, generate a lead report in Google Sheets, and send it via email and SMS.

Pain Points Alleviated: Streamlines the prospecting process, improves lead management efficiency, and ensures timely follow-ups.

Restaurant Recommendation Automation

1
Webhook (Trigger)
2
OpenAI (ChatGPT)
3
Google Sheets (Save Recommendation)
4
Email (Send Recommendation)
5
Error Handling (Webhook Response)
6
Quality Control (Review Recommendations)
7
SMS (Send Confirmation)
8
Formatting (Format Message)
9
Notification (Slack)
10
Log (Write)

Automatically generate restaurant recommendations based on user preferences and save them in a Google Sheet, followed by sending the recommendations via email and SMS.

Pain Points Alleviated: Enhances user experience by providing personalized recommendations promptly and automating the communication process.

Client Communication Automation

1
HTTP Request (Trigger)
2
CRM (Get Client Data)
3
OpenAI (ChatGPT)
4
Email (Compose Message)
5
SMS (Send Message)
6
Error Handling (Webhook Response)
7
Quality Control (Message Review)
8
Formatting (Template Usage)
9
Notification (Slack)
10
Log (Write)

Automatically fetch client data from a CRM, generate personalized messages using ChatGPT, and communicate with clients via email and SMS.

Pain Points Alleviated: Improves client engagement and reduces time spent on drafting communications manually.

Data Collection and Reporting Automation

1
Scheduled Job (Trigger)
2
Google Forms (Get Responses)
3
OpenAI (ChatGPT)
4
Google Sheets (Update Report)
5
Email (Send Summary)
6
Error Handling (Webhook Response)
7
Quality Control (Data Check)
8
Formatting (Create Chart)
9
Notification (Slack)
10
Log (Write)

Collect data from Google Forms, analyze responses with OpenAI, update summarized reports in Google Sheets, and send summaries via email.

Pain Points Alleviated: Simplifies reporting processes, improves data insights, and fosters timely communication within teams.