How it works

• Weekly trigger starts the workflow.

• Google Ads data is pulled into Sheets.

• Google Slides auto-populates with charts.

• Slack notifies the team with the finished deck.

Apps involved

• Google Ads: Supply ad performance and creative metadata

• Google Sheets: Log structured rows with owners, dates, and statuses

• Google Slides: Generate slides from a template with key metrics

• Slack: Notify channels with links for review and follow up

Business benefits

• Save hours on reporting.

• Standardize weekly updates.

• Keep marketing and leadership aligned.

Automate weekly ad reporting by turning Sheets data into Slides and sharing updates directly to Slack.