Step-by-step: Automating weekly performance report generation with Notion AI and Zapier

Overview

Automating a weekly performance report saves time and ensures consistency. The workflow below uses:

1. Data source – a Google Sheet that receives raw metrics (e.g., sales, traffic, support tickets).
2. Trigger – Zapier runs every Monday at a set time.
3. Data enrichment – Zapier pulls the latest rows, formats them, and sends them to Notion.
4. AI summary – Notion AI reads the table and generates a concise narrative.
5. Report assembly – Zapier combines the table and AI text into a Notion page, exports it as PDF via PDF.co, and emails the file.

All steps are configurable in the free tiers of the services; paid upgrades are only needed for higher volumes or premium features.

Step 1: Prepare the data source

• Create a Google Sheet with columns for each metric you track (date, value, category, etc.).
• Ensure rows are appended weekly by your existing data pipeline (e.g., a script, Zapier webhook, or manual entry).
• Add a header row; Zapier will read the sheet starting at row 2.

Step 2: Set up the Zapier trigger

1. In Zapier, create a new Zap.
2. Choose Schedule by Zapier → Every Week → select Monday and the time you want the report to run.
3. Test the trigger to confirm Zapier fires on schedule.

Step 3: Fetch the latest data from Google Sheets

1. Add action Google Sheets → Lookup Spreadsheet Row (or Get Many Spreadsheet Rows if you need the full week).
2. Connect your Google account, select the spreadsheet and worksheet.
3. Set the query to pull rows where the date column is within the last 7 days (use a Zapier formatter step to calculate the date range).
4. Test the action; you should see a JSON array of the week’s rows.

Step 4: Send data to Notion

1. Add action Notion → Create Database Item.
2. Create a Notion database (if you don’t have one) with properties matching your sheet columns plus a Summary text field for AI output.
3. Map each Google Sheet column to the corresponding Notion property.
4. Leave the Summary field empty for now; it will be filled by Notion AI.
5. Test – a new page should appear in your Notion database.

Step 5: Generate the AI summary

Notion AI works inside a Notion page. To trigger it via Zapier:

1. Add action Notion → Update Database Item.
2. Use the page ID from the previous step.
3. In the Summary field, insert a Zapier formatter step that calls Notion AI via the Custom Request action (Notion’s API supports the ?ai=summary parameter on a block).
   • Simpler approach: Use Notion → Append Block with a paragraph block containing the prompt:

     Summarize the following performance data in 3‑4 bullet points:
     {{JSON from Google Sheets}}
     

   • Notion AI will auto‑complete the block with a summary.
4. Test the update; the Summary property should now contain AI‑generated text.

Step 6: Assemble the report and export to PDF

1. Add action Notion → Get Page Content to retrieve the full page (table + AI summary).
2. Add action PDF.co → HTML to PDF (or PDF.co → Anything to PDF).
   • Convert the Notion page’s public share URL to HTML using Zapier’s Webhooks → GET (if you have the public link) or use Notion’s Export via the API (requires a paid Notion plan for API export).
   • If you lack a public URL, use Notion → Export Page as PDF directly via the Notion API (available on Team/Enterprise plans).
3. Test the PDF.co step; you should receive a downloadable file link.

Step 7: Email the report

1. Add action Gmail → Send Email.
2. Set recipient(s), subject line (e.g., “Weekly Performance Report – {{date}}”), and body (brief note).
3. Attach the PDF file from the previous step (use the file URL from PDF.co).
4. Test the email; verify the attachment opens correctly.

Step 8: Turn on the Zap

• Review all steps, ensure each test succeeded.
• Switch the Zap to On.
• Optionally add a filter step to skip runs when no new data exists (e.g., check row count > 0).

Maintenance tips

• Data latency – If your source system updates later in the day, adjust the schedule to run after the data is guaranteed.
• Quota watch – Free Zapier plans limit tasks/month; monitor usage or upgrade if you exceed limits.
• Notion AI limits – Notion AI usage is tied to your workspace plan; check the fair‑use policy if you generate many summaries weekly.
• Error handling – Add a Zapier → Email by Zapier step on any failed action to alert you instantly.

By following these steps, you’ll have a repeatable, zero‑manual‑effort process that delivers a polished PDF performance report every week, powered by Notion’s AI summarization and Zapier’s automation glue.