Collect ad performance files from Google Drive, read both spreadsheets and CSV files, and turn them into clear optimization advice that is sent by email. Great for marketers and ecommerce teams that want weekly actions without digging through reports. The goal is simple: save time and get targeted changes you can apply fast.

The flow starts when you run it in n8n. It lists files in a selected Google Drive folder, downloads each one, and keeps the original file names for tracking. A branch checks the file type, then extracts rows from XLSX or CSV. The results join back together and a code step cleans and bundles the data. An OpenAI chat model reads the cleaned data with system rules and produces practical insights. A Gmail node assembles the message and sends the recommendations to your chosen inbox.

Set up needs access to Google Drive, Gmail, and OpenAI. Place your ad reports in one Drive folder and keep consistent names so the routing works. Most teams see report prep drop from hours to minutes and gain a steady rhythm for weekly or daily improvements. This is useful for agencies managing multiple brands, in house teams tracking performance, or solo sellers who want quick wins with less busywork.

• Google Drive file listing and download from a chosen folder
• File type check to route XLSX and CSV through the right parser
• Extract from File nodes read spreadsheet and CSV rows
• Preserves original file names for audit and traceability
• Merge step combines data from both file types into one stream
• Code step cleans and formats the bundled data for AI input
• OpenAI chat model produces clear, action focused insights
• Gmail node sends a formatted summary with recommendations
• Email Options node lets you set recipients and subject

• Reduce manual report prep from 2 hours to 10 minutes
• Automate 80 percent of weekly optimization prep
• Improve data consistency by 90 percent with single source files
• Connect Google Drive, OpenAI, and Gmail in one flow
• Scale to handle more reports without extra staff time

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Drive, Gmail and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, connect Google Drive: open the List Files or Get File node, choose Credential to connect with, click Create new credential, then follow the on screen steps to authorize your Google account.
4. Connect Gmail: open the Email Optimizations node, choose Credential to connect with, click Create new credential, then follow the on screen steps to authorize your Gmail account.
5. Connect OpenAI: open the OpenAI Chat Model node, choose Credential to connect with, click Create new credential, and paste your API key from the OpenAI account settings page.
6. In the List Files node, select the Google Drive folder that holds your ad reports. Make sure the account you authorized has access to that folder.
7. Open the Email Options node and set the send to address, subject, and any message headers you want.
8. Check the file routing: open the is XLSX node and confirm your reports end with .xlsx or .csv so each file goes to the right Extract node.
9. Click Execute workflow to run a test. Verify Extract XLSX Data and Extract CSV Data return rows, and check that Preserve File Name keeps the fileName field.
10. Open the AI Analyze node and review the system instructions. Adjust the wording to match your optimization rules and goals.
11. Send a test email to yourself. Confirm the Gmail node delivers a clear summary with recommendations and that links or metrics display correctly.
12. Optional scheduling: replace the manual trigger with a Cron node to run daily or weekly, or add a Drive watcher flow to process new files as they arrive.