Monthly Canva Report Automation

I need a fully-automated marketing report that lands in a dedicated Canva folder at 00:01 on the first day of every month, covering the performance of the previous month. The file must remain 100 % editable by my team in Canva, so any charts, figures, or text blocks should update without breaking the design.

Data sources to connect
• Google Ads
• SERanking
• GA4 (I already use it elsewhere in my stack; please include it even though it wasn’t in the check-box list)

Key Google Ads metrics to surface
• Clicks and Impressions
• Conversion Rate
• Cost per Click
• Clicks Share
• Ad Spend

Key SERanking metrics to surface
• Keyword Rankings
• Backlink Data
• Website Audit Score

Flow I picture
1. Pull the raw data via API, Supermetrics, Looker Studio, Zapier, or any other reliable connector you recommend.
2. Transform it so the figures roll up neatly into month-to-date totals and trend graphs.
3. Populate a branded Canva template (I’ll supply colours and fonts) and save the finished file inside a pre-named Canva folder each month without manual intervention.

Acceptance criteria
• Every metric above appears in the report with correct figures when we test against source platforms.
• A new file is auto-generated on the scheduled date/time for two consecutive months.
• My team can change fonts, colours, or layout in Canva without breaking live data links.

If you have clever ways to keep the workflow light and reliable, let me know in your proposal along with the tech stack you’d use.