In this AI marketing podcast episode, Dan Sanchez and his brother Travis dive deep into the latest AI-powered capabilities in Google Sheets and how they're revolutionizing everyday marketing workflows. From automated spreadsheet completion to real-time data analysis and reporting, Dan shares specific examples of how Gemini is saving hours of work and turning spreadsheets into smart, dynamic tools. Whether you're managing content calendars or analyzing survey responses, this episode reveals how AI is transforming how marketers use spreadsheets.

My Favorite AI Tools:

Tella (AI screen recording app I record all my solo episodes with) - https://danchez.com/tella
High Level (My all-in-one marketing platform) - https://danchez.com/highlevel
Zencastr (Best AI podcast tool) - https://danchez.com/podtools
n8n (my favorite AI automation tool) - https://danchez.com/n8n

Resources Mentioned:

Google Sheets Gemini AI - https://workspace.google.com/blog/product-announcements/duet-ai-in-google-sheets
Clay (for AI data enrichment) - https://www.clay.com/
Gamma (AI-powered presentation tool) - https://gamma.app/
Turning your podcast into social posts: https://smack.fm

Timestamps:

00:00 - Do you love spreadsheets? The kind of marketer that says a lot
02:00 - AI in Google Sheets is finally a real workflow enhancer
04:30 - Dan shares how Gemini filled in an entire Bible study worksheet
06:30 - When Gemini hallucinates: where AI in Sheets still falls short
08:15 - Use Gemini as a cell-level formula to categorize qualitative survey data
11:30 - Reporting magic: Gemini pulls podcast view data from multiple tabs and summarizes it
14:30 - The future of automating social media analytics with AI + Chrome
17:30 - Why High Level's fixed pricing and Google Sheets integration is a game-changer
21:00 - Turning podcast episodes into book chapters using Gemini
27:00 - Emotional processing and marriage fights: a surprising use case for AI
31:00 - Viral post: Claude cuts $195K hospital bill down to $33K
35:00 - Using AI for second opinions on legal and financial documents

The Secret AI Power Hiding Inside Google Sheets

AI-Driven Marketer: Master AI Marketing To Stand Out In 2025