Connect Twitter Ads to Google Sheets: Complete Tutorial(2026)

Struggling to track your client’s ad performance in X Ads Manager? With Two Minute Reports, you can automatically pull your X (Twitter Ads) data into Google Sheets, so you can always share the latest performance insights with your clients without the manual grind.

How to connect Twitter Ads to Google Sheets?

You can connect Twitter Ads data to Google Sheets through the Two Minute Reports Hub. It is your centralized workspace for managing all your connections, clients, and destinations. Here’s how to get started:

Step 1: Creating a Connection

1. Go to hub.twominutereports.com and click Connections → Create Connection.

2. Inside the dialog box, complete these three steps:

• Select the Twitter Ads connector from the list of options.

• Enter the name for your Connection and authorize it by logging in with your credentials.

• Enable the Twitter Ads accounts you want to measure performance for. Please note that you can’t query the disabled accounts.

3. Once done, navigate back to the Hub Homepage and click Google Sheets → New Google Sheets Report.

4. Click Use Template and follow the on-screen instructions to launch the Two Minute Reports add-on in your spreadsheet.

Step 2: Configure and Run Your Query

1. Once you’ve installed the add-on, navigate to Menu → Data Queries and click Add.

2. Select the Twitter Ads accounts that you want to include from the sidebar.

3. If you're managing multiple clients, go to Clients → Manage Clients (in the sidebar), map your Twitter Ads accounts to the relevant clients, and click Save & Close.

4. Choose relevant Twitter Ads metrics and dimensions and select your date range.

5. Click Run Query to pull the data into your chosen sheet and cell.

6. The next step is to Save & Automate your query. Then, follow the steps below:

• First, enter your schedule name. 
• Next, select the queries to include in this schedule. You can choose multiple queries if you want them to refresh on the same schedule.
• Then, choose how often you want to refresh – hourly, daily, weekly and monthly. 
• Specify the exact time and timezone for the refreshes to occur.

Once you are done with the above steps, you can set up your reports to be delivered via email. Here’s how you can:

• To enable email delivery, move the toggle to ‘Email’.
• Next, select the Sheet to report. 
• Enter the email addresses of your recipients – your clients, team members or stakeholders.
• Select whether you need to attach the report as a PDF, Excel/CSV or both.
• Write a customized email subject and body message to include with each report.

And that’s it. Your schedule is now saved. From here on, your clients will receive the latest X Ads campaign performance insights at defined intervals.

Prefer to work directly inside Google Sheets? You can also connect Twitter Ads to Google Sheets by installing the Two Minute Reports add-on from the Google Workspace Marketplace, following the steps below:

• Open a spreadsheet. Launch the add-on from Extensions → Two Minute Reports → Launch.
• Click Menu → Connections → Add and select the Twitter Ads connector.
• Authorize your account and enable the accounts you want to query.
• Click Refresh Connections to confirm your accounts appear in the sidebar.

Once connected, follow the same query steps above to start pulling your Twitter Ads data directly into Google Sheets.

Why export X Ads data to Google Sheets?

Marketers and agencies need fast, flexible reporting, and the native X Ads manager just doesn’t cut it. Here’s why moving your X Ads data to Google Sheets can transform your reporting workflow:

Get deeper visibility into X Ads performance

With X Ads data in Google Sheets, you can work with a broader set of performance metrics, including:

• Spend, clicks, impressions, CTR, CPC, and CPM.
• Link clicks, app clicks, and cost per link click
• Likes, retweets, replies and follows
• Video views and views at 25%, 50%, 75% and 100% completion
• Billed engagement and other campaign performance metrics

You can then use Google Sheets formulas, pivot tables, filters, and charts to turn these metrics into reports that fit your reporting needs.

Analyze campaigns, ad groups, and ads in one place

X ads data becomes easier to organize when you can break down performance by the dimensions that matter to your campaigns. In Google Sheets, you can analyze data by:

• Campaign name, ID, and status
• Ad group name, ID, objective and goal
• Ad and Tweet ID
• Campaign and ad group budgets
• Campaign currency and account details
• Date, week, month or year

This makes it easier to compare campaigns, identify changes in performance, and build recurring campaign reports from the same dataset.

Automate your X Ads reporting

Manually downloading and cleaning X Ads data every week adds unnecessary work to your reporting process.

With Two Minute Reports, you can bring your X Ads data directly into Google Sheets and keep your reports refreshed automatically. Set up your report once, choose the metrics and dimensions you need, and use the same reporting workflow for your recurring updates.

You don’t need repeated CSV exports or manual data preparation. Decide your next action with the auto-refreshed X ads insights in your spreadsheet.

Combine X Ads with other platforms

Through data blending, you can combine your X Ads data with other PPC platforms and create a reporting view tailored to your agency and marketing team. Spot which platform performs the best for each audience and make strategy decisions with all your data in one place.

Important metrics used in the X Ads Google Sheets Reports

The X Ads integration with Google Sheets lets you extract key performance metrics to understand how your campaigns perform and drive engagement. Here are some of the most useful X Ads metrics you can track and optimize:

Metric	What does it tell you?	Optimization tip
Amount Spent	Tracks the total amount spent on your X ads campaigns, ad groups or ads.	Compare spend against engagements and other performance metrics to identify campaigns that are using budget effectively.
Click-through rate (CTR)	Shows the percentage of impressions that resulted in clicks.	Improve your ad copy and creative to make your ads more relevant and compelling.
CPC	Measures the average amount spent for each click	Identify ads with high CPC and test new creatives or targeting to improve click efficiency.
Cost per link click	Shows how much you spend, on average, for clicks on links.	Optimize campaigns for lower link click costs by testing different messaging, creatives and audiences.
CPM	Measures the average cost of generating 1000 impressions	Monitor CPM alongside CTR and engagement rate to determine whether higher reach is translating into meaningful interaction
Retweets	Shows how often users retweeted your ad	Analyze ads with higher retweet activity to understand which topics or messages encourage sharing
App clicks	Measures clicks that lead users to install or open your app.	Compare app-click volume and cost across campaigns to identify the most efficient app promotion campaigns.
Video views	Tracks the number of times users viewed your video ad.	Compare video views with video completion rate metrics (25%, 50%, 75% and 100%) to understand whether your videos hold attention

Ready to Connect your X Ads to Google Sheets?

Connecting X Ads to Google Sheets gives you a flexible way to access, analyze and automate your campaign insights. With key X Ads KPIs, you can build reports around the metrics that matter most to your advertising strategy.

With Two Minute Reports, you can streamline the entire process by automatically bringing your X Ads data into Google Sheets, so you can keep your advertising data ready for action whenever you need it.

Set up your data pipeline

Take my data from

Select a data source

Save my data to

Google Sheets

PROCEED