Free X Ads (Twitter Ads) to Google Sheets Connector by OWOX: Simplify Tracking Ad Performance

Running campaigns on Twitter (now X) is simple. But turning X Ads data into meaningful reports in Google Sheets? That’s where most marketers hit a wall.

If you’ve ever tried analyzing campaign performance outside of X’s native dashboard, you’ve probably wrestled with incomplete CSV exports, limited field access, and clunky manual updates.

That’s exactly why we built this.

With this 100% free, no-code connector from OWOX, you can import, refresh, and customize Twitter Ads data in Google Sheets effortlessly. You decide what to pull, how to organize it, and how often it updates. No black boxes. No vendor lock-in. Just clean, structured ad data you can use.

Note: Twitter Ads has been rebranded to X Ads following the platform's name change in 2023. In this article, we use both terms interchangeably to help you familiarize yourself with either name.

Why We Made This Free Connector

At OWOX, we believe marketers shouldn’t have to jump through hoops to access their campaign data.

That’s why we built this 100% free connector for Twitter Ads (X Ads) to Google Sheets, with no usage limits, hidden upgrades, or premium tiers. Just instant access to the metrics that matter.

If you're tired of working around X’s limited exports or struggling with rigid dashboards, this tool gives you complete flexibility. Choose your fields, filter by date, and build reports that reflect how your campaigns perform.

This connector was made for marketers who want answers, not obstacles.

Join the Open-Source Movement

We’re not just releasing a free connector, we’re inviting you to help shape the future of open marketing analytics tools.

At OWOX, we believe that data access and transparency should be a right, not a luxury. That’s why this connector, a part of OWOX Data Marts (Community Apps Script Edition), is 100% open-source, giving you full control over how it works, what it does, and how far it can go.

If you like what we do, please ⭐ star our GitHub repo to show your support – it helps us reach more analysts and grow the number of available connectors.

Also, feel free to:

• Explore the code and customize it to fit your needs.
• Contribute to this data connectivity ecosystem: suggest new connectors, pull new connectors, and / or documentation to support the wider community.
• Join our community & share your feedback.

We’ve built the core, the foundation – now it’s your turn to take it further.

Why Choose the OWOX Free Connector?

Most tools that claim to bring Twitter Ads (now known as X Ads) data into Google Sheets come with a catch: subscription fees, usage caps, limited field support, or opaque backends you can’t control. 

Some rely on middleware platforms, others offer only partial data access, or force you into their reporting templates.

This connector doesn’t.

✅ Built specifically for sending raw Twitter Ads data directly into Google Sheets – no extra platforms, logins, or pipelines.
✅ 100% free and open-source – not a trial, not a freemium plan. Just full access, forever.
✅ No hidden columns or restricted fields – select exactly the metrics and dimensions you need, as supported by the Twitter Ads API.
✅ Works inside Google Sheets with familiar controls – no new dashboards to learn or APIs to manage.
✅ Fully transparent – view, audit, and modify the Apps Script powering the connector whenever you want.

If you're tired of connectors that charge more for each new ad account, limit your refresh rate, or hide what's happening under the hood, this connector, which is a part of OWOX Data Marts (Community Apps Script Edition), gives you a cleaner, simpler alternative. 

Why Bring Twitter Ads Data into Google Sheets?

Twitter Ads Manager is designed for launching campaigns, rather than conducting in-depth analysis or multi-source reporting.

❌ Metrics are limited and locked in
❌ CSV exports go stale fast
❌ No built-in way to join with GA4, CRM, or cost data

That’s why this 100% free Twitter Ads to Google Sheets connector exists.

✅ Pull raw ad data into Sheets whenever you need it
✅ Join it with other sources for full-funnel visibility
✅ Customize your own ROAS, attribution, and performance models

With total control over fields, filters, and structure, all inside Google Sheets, you’re free to report the way you want.

Check out our other free connectors:
Loving how easy it is to report on Twitter Ads? You can do the same with:
‍
Twitter Ads → BigQuery
Facebook Ads → Google Sheets
TikTok Ads → Google Sheets
Reddit Ads → Google Sheets
‍
Free to use. Easy to set up. Built for better reporting.

‍

Google Sheets

Data sources

Free X Ads (Twitter Ads) Connector to Google Sheets

Download template

How the Connector Works

At OWOX, we aimed to create a connector that meets the needs of analysts while being intuitive enough for marketers to use as well. That’s why we built it entirely inside Google Sheets using Apps Script, no coding, no third-party tools, no paid platforms.

Here’s what powers it:

• Built with open-source Google Apps Script so that you can inspect, modify, or extend the code freely. No black boxes, just full transparency.
• Pulls raw, structured data from the Twitter Ads (X Ads now) API. You can choose exactly which metrics, dimensions, and fields to include, with full control over time ranges, aggregation, and time zones.
• Paste the results directly into your spreadsheet so that you can build performance dashboards.

And yes, this connector is 100% free, with no restrictions or usage limits. You own the connector. You own your data.

Whether you're an in-house marketer, a freelance strategist, or part of a reporting team, this tool helps you:

• Avoid vendor lock-in and overpriced data tools
• Automate Twitter Ads reporting without leaving Sheets
• Share and collaborate with your team using familiar tools

This isn’t just another connector; it’s your first step toward full control over your paid social reporting.

Step-by-Step: Import Twitter Ads Data to Google Sheets

This is where the magic happens. In just a few minutes, your Twitter Ads (X Ads now) data will be flowing into Google Sheets, no code, no roadblocks, just clean, structured results ready for analysis.

Let’s walk through the setup step by step.

Step 1: Copy the Google Sheets Template ( ~1 min)

To streamline the setup process, use our pre-configured Google Sheets template; no need to build from scratch.

1. Access the Template

• Open the “X Ads → Google Sheets. Template” from OWOX.
  
  

2. Create a Personal Copy
   
   • Go to File → Make a copy to save it to your Google Drive.

Master Twitter Ads → Google Sheets Reporting With Our Free Template!

Say goodbye to CSV exports and complex APIs – this plug-and-play Google Sheets template lets you pull Twitter Ads data effortlessly.

Download your FREE template today!

Step 2: Configure the Source ( ~2 min)

Fill in key settings on the “Config” sheet to define what and where to import.

1. Set the Start Date

• Choose how far back you want to pull data from.
  Tip: Use shorter ranges to avoid timeouts.
  
  

2. Add Your Account ID(s)

• Log into https://ads.x.com.
• The account ID is in the URL after /campaign_form/.
  Example: https://ads.x.com/campaign_form/18ce55in6wt/campaign/new
  Account ID = 18ce55in6wt

3. Select Your Fields

• Go to the Fields tab
• Check the boxes for all the data you want to import.
  

Further Specify the Fields with the Following Parameters:

• Destination Spreadsheet – Leave blank to load data into the currently open spreadsheet.
• ReimportLookbackWindow: Days to look back when reimporting data (default: 2)
• MaxFetchingDays: Max number of days to fetch per run (default: 31)
• ReimportLookbackWindow: Days to look back when reimporting data (default: 2)

Step 3: Get a Twitter Ads Access Token ( ~30 seconds)

To connect the template to your Twitter Ads (now X Ads) account, you’ll need four credentials: API Key, API Secret, Access Token, and Access Token Secret. Follow the steps below to generate them securely.

1. Visit the Twitter Developer Portal

• Sign in to developer.x.com. 

• A default app is created for you automatically. 

Note:  If prompted to upgrade your account, choose the Free tier to proceed without charges.

2. Request Ads API Access

Before using the connector, you must request access to the X Ads API.

• Fill out the official X Ads API Access Request Form.
• Alternatively, you can message @AdsSupport for assistance.
• Provide your App ID (found on your app’s detail page).
  

• In the form, describe how you’ll use the API. For example:
  
  

“We are advertisers looking to connect with the X Ads API to access campaign data for analysis and optimization. The data will be pulled via the OWOX Data Marts platform and used to support strategic decision-making across our marketing efforts.”

• For “What level of Ads API access do you need?”, choose: Standard Ads API access.
  

• After submitting, monitor your email inbox for approval. You’ll receive a confirmation once your X Ads API access is granted.

3. Configure Your App

• Navigate to the app’s User Authentication Settings.
• Click Edit.

• Under App Permissions, select: Read and write.
  

• Set Callback URI to: http://localhost.
• Leave all other fields as default.
• Click Save.

4. Generate API Keys

Go to the Keys and Tokens tab:

• Click Regenerate in the API Key and Secret section → Save both values. 

These are your Consumer Key and Consumer Secret.

5. Get Request Token (via OAuth 1.0)

Using a tool like Postman:

• Make a POST request to: https://api.twitter.com/oauth/request_token
• Use OAuth 1.0 in the Authorization tab:
  
  
  • Signature Method: HMAC-SHA1
  • Consumer Key 
  • Consumer Secret 
  • Callback URL: http://localhost

• Click Send.

The response will look like: 

oauth_token=E4MQKQAAAAAB1yCFAAABl2OHH80&oauth_token_secret=UlDQaqOoJHj1VvLQ8fQH6Iq686rEFww2&oauth_callback_confirmed=true

• From the response, copy the oauth_token  (E4MQKQAAAAAB1yCFAAABl2OHH80 )  and insert it into:
  https://api.twitter.com/oauth/authorize?oauth_token=YOUR_OAUTH_TOKEN

• Open this URL in your browser and click Authorize App.

• You’ll be redirected to a new URL containing:
  
  • oauth_token
  • oauth_verifier

6. Get Permanent Access Token

Back in Postman:

• Make a POST request to: https://api.twitter.com/oauth/access_token
  
  
• Use OAuth 1.0 with the following:
  
  • Consumer Key: your API Key
  • Consumer Secret:  your API Secret
  • Access Token: oauth_token
  • Access Token Secret: oauth_token_secret
  • Verifier: oauth_verifier 
  • Callback URL: http://localhost

• Click Send. 
• You’ll get a response containing your final credentials.
  
  • oauth_token=1534231826281152515-kDGnM70as1fh6xoYWK9HvlwtDHHqe8&
  • oauth_token_secret=KiXVKSyHifVoVm7vq3iC7zjclE1ocqvgpouS95RuLXM61&user_id=1534231826281152213&screen_name=examplename

You now have all the required credentials:

• Consumer Key (API Key)
• Consumer Secret (API Secret)
• Access Token (oauth_token)
• Access Token Secret (oauth_token_secret)

Step 4: Input Access Token into the Template ( ~10 seconds)

Connect your template to X Ads using the credentials you generated.

1. Open the Credentials Menu

• Open your copied Google Sheets template.
  In the top menu, click: OWOX → Manage Credentials.

2. Authorize the App Script

When prompted:

• Click "OK" to allow the Apps Script to authorize and access your Google Sheet.
• This enables the connector to fetch and insert data.
  

3. Add Your Token Details

• Paste your Consumer Key, Consumer Secret, Access Token and Access Token Secret into the form.

• Click Save.

This step activates the connector with the correct credentials.

Step 5: Import Data into Google Sheets  ( ~1 min)

Now it’s time to bring the data in.

1. Start the Import

• In the spreadsheet menu, click: OWOX → Import New Data
  

• The connector will begin fetching data from your selected X Ads account(s).
  
  

2. You’ll know the process is complete when the Logs sheet displays the message: “Import is finished.”

• Your X Ads data will appear in newly created tabs within the Google Sheets template (e.g., accounts, posts, metrics).

Real-Time Visualization with OWOX Reports

Want to go beyond raw X Ads data?

Use the OWOX: Reports, Charts & Pivots Extension for Google Sheets to turn your Twitter Ads data into interactive dashboards, no scripts, formulas, or Looker Studio required.

With OWOX Reports Extension, you can:

📊 Turn raw data into dashboards in seconds
📥 Use prebuilt pivot tables and chart generators
✅ Share results across your team – no Looker Studio or BI setup needed

Use your data directly inside Google Sheets to drive decisions faster, with no manual formatting, no broken formulas, and no extra cost.

What’s Next?

This free connector, built with OWOX Data Marts (Community Apps Script Edition), is part of our mission to give marketers full control over their advertising data, without code, cost, or compromise.

Here are more resources worth exploring:

🔗 More free connectors – including LinkedIn Ads, Microsoft Ads Connectors for Google Sheets, and other essential marketing platforms
🎥 Step-by-step video tutorials – to help you get up and running faster
📊 Ready-to-use dashboards – built for ROAS, attribution, and performance tracking in Google Sheets

Explore the GitHub repo, leave us a ⭐ star, and help shape the future of open ad reporting.

Google Sheets

Data sources

Free X Ads (Twitter Ads) Connector to Google Sheets

Download template