Daily Google Ads recap in Notion and a spreadsheet

Each morning the scenario exports yesterday's clicks and conversions from the ad dashboard, merges them, and writes the report to AWS DynamoDB and ClickUp.

  • Collects yesterday's clicks and conversions
  • Rolls them into a daily total
  • Writes to AWS DynamoDB and ClickUp
  • Ready every morning, no manual export
Google