Automated TikTok Ads Daily Spend Export
Every morning, WebRun signs in to TikTok Ads Manager, reads yesterday's spend, impressions, clicks, and conversions for every active campaign, appends one dated row per campaign to your Google Sheet, and drafts a Gmail summary calling out the campaigns whose cost per result moved most.
How do I export TikTok Ads spend into a spreadsheet every day?
WebRun signs in to TikTok Ads Manager every morning and reads yesterday's spend, impressions, clicks, and conversions for each active campaign. It appends one dated row per campaign to your Google Sheet and drafts a Gmail summary of the biggest cost-per-result movers, so your reporting is done before you start work.
- Yesterday's numbers are in the sheet before you open your laptop
- Cost-per-result swings are compared against each campaign's own seven-day average
- The spend history builds day by day without anyone copying numbers by hand
Built for performance marketers · ecommerce brands · media buyers · marketing agencies
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
ads.tiktok.com/i18n/loginin a real browser with your saved login - no setup, no API keys. -
1
TikTok Ads - read yesterday's campaign numbers
ads.tiktok.com
WebRun opens TikTok Ads to read yesterday's campaign numbers. - Sign in to TikTok Ads Manager and open the Campaign view
- Set the date range to yesterday
- Read spend, impressions, clicks, conversions, and cost per result for each active campaign
- Note any campaign that ran out of budget or was paused during the day
Done when Yesterday's numbers are captured for every active campaign.
-
2
Google Sheets - append one dated row per campaign
google.com
WebRun opens Google Sheets to append one dated row per campaign. - Open your ad performance Google Sheet
- Append one row per campaign with the date, campaign name, spend, impressions, clicks, conversions, and cost per result
- Never overwrite an earlier day, so the history builds up run by run
- Add the daily total on the summary tab
Done when Yesterday has one clean row per campaign in the sheet.
-
3
Gmail - draft the summary of what moved
gmail.com
WebRun opens Gmail to draft the summary of what moved. - Draft a short email with yesterday's total spend and the three campaigns whose cost per result moved most
- Compare each against its own seven-day average, not a made-up benchmark
- Leave the email as a draft for you to read and forward. It is never sent on its own
Done when A summary of yesterday's spend is waiting in your Gmail drafts.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it change my budgets or pause campaigns?
No. WebRun only reads TikTok Ads Manager. It never edits a budget, a bid, a creative, or a campaign status. Every spending decision stays with you.
Does it email the summary out on its own?
No. The Gmail summary is left as a draft for you to read and forward. Only the Google Sheet is written automatically, and it only ever appends new rows.
Can it cover several ad accounts?
Yes. List each TikTok Ads account you manage and WebRun walks them in turn, writing one row per campaign per account into the same dated sheet.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.