Free Reddit Ads to Google Sheets Connector by OWOX: Take Control of Your Campaign Data

Reddit Ads are straightforward to launch, but turning that campaign data into useful insights in Google Sheets isn’t. Downloading CSVs every day, cleaning up inconsistent fields, and stitching reports together manually wastes time and invites errors. 

Most tools either lock your data behind paywalls or limit how much you can access. Well, now you can skip the clunky dashboards, messy CSV files, and overpriced tools that restrict access or charge by volume.

With this free, open-source connector from OWOX Data Marts (Community Apps Script Edition), you can move raw Reddit data to Google Sheets–no code, no barriers, no surprises. Just simple Reddit Google Sheets integration with full control and complete transparency.

Why We Made This Connector

At OWOX, we believe marketers and analysts should have full access to their advertising data - no paywalls, limits, or hidden logic.

That’s why we created this 100% free Reddit to Google Sheets connector. No pricing tiers, no data caps, and no locked fields. It’s fully open-source, built with Google Apps Script, and gives you complete visibility into how the Reddit Google Sheets integration works.

There’s no fixed schema or forced platform. Just a direct, flexible way to move raw Reddit Ads data to Google Sheets–perfect for building custom reports, tracking performance, or integrating with other tools like GA4 or HubSpot.

💡 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 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 provide 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 This Free Connector by OWOX  

Most Reddit to Google Sheets tools seem easy, until you dig in. You’ll face rigid structures, missing fields, usage limits, or features locked behind paywalls.

OWOX takes a different approach:

• 100% free and open-source – No trials, no restrictions. You get full access from day one.
• No vendor lock-in – It runs in your spreadsheet. No account needed, no hosted setup, and zero risk of losing access.
• Powered by Google Apps Script – No third-party tools, paid platforms, or syncing issues. Just native Google Sheets integration.
• Fully transparent – Unlike other tools, you can view and edit the entire setup yourself.
• Field-level control – Import only the Reddit Ads metrics you need, nothing more.

Whether you're evaluating alternatives like Rivery, Windsor.ai, or Portable, this Google Sheets Reddit integration gives you full control without added cost or complexity.

Google Sheets

Data sources

Free Reddit Ads Connector to Google Sheets

Download template

Why Send Reddit Ads Data to Google Sheets?

Reddit Ads Manager is great for launching campaigns, but not for deep analysis, flexible reporting, or integration with other platforms.

❌ Reporting views are limited with no customization options
❌ Manual CSV exports are slow, error-prone, and hard to maintain
❌ No native way to connect Reddit Ads data with GA4, CRM, or cost-tracking tools

That’s why we created this free Reddit to Google Sheets connector from OWOX Data Marts (Community Apps Script Edition):
✅ Automatically send raw Reddit Ads data into Google Sheets with no coding required
✅ Combine Reddit data with GA4, Salesforce, HubSpot, or Meta Ads to build full-funnel reports
✅ Create your own metrics, retention charts, or ROAS models directly in Google Sheets

With full control over what data you bring in and when it refreshes, this Reddit Google Sheets integration gives analysts the speed, flexibility, and ownership they’ve been missing.

Explore More Free Connectors
Already loving the freedom of Reddit Ads reporting? Add more power to your workflow with these ready-to-use, no-code integrations:

• Reddit Ads → BigQuery
• Twitter Ads → Sheets
• Facebook Ads → Sheets
• TikTok Ads → Sheets
  No fees, no code – just fast, flexible reporting across every ad platform you use.

How the Connector Works  

The Reddit to Google Sheets integration is powered entirely by open-source Google Apps Script – no third-party tools, no coding hassles, and no usage limits.
Here’s how it works:

• Connects directly to the Reddit Ads API and streams structured data into your Google Sheet.
• Gives you full control over fields, metrics, dimensions, and date ranges - customize exactly what you need.
• Automatically refreshes data inside your sheet, ready for analysis, dashboards, or exports.

Whether you're blending Reddit data with GA4, CRM, or cost sources, or building ad performance dashboards, this Reddit Google Sheets integration lets you:

• Skip CSV exports and complicated ETL tools
• Automate Reddit Ads reporting in Sheets at scale
• Run fast, flexible, and transparent analysis

From data pull to daily tracking, you own the Reddit to Google Sheets setup - no black boxes, just full visibility and control.

Step-by-Step: Import Reddit Ads Data into Google Sheets

Here’s where the real power kicks in. In just a few minutes, your Reddit Ads data starts flowing into Google Sheets - no coding, no roadblocks. Just clean, organized data ready for tracking, analysis, and integration with other sources.

Let’s walk through the setup step by step. 

Step 1: Copy the Google Sheets Template (~ 30 sec)

Start with our ready-to-use Reddit Ads → Google Sheets template - no manual setup required.

• Access the Template
  Open the “Reddit Ads → Google Sheets. Template” template shared by OWOX.
• Make a Copy
  Click File → Make a copy to save the template to your own Google Drive and begin configuring.

Master Reddit 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 Reddit Ads data effortlessly.

Download your FREE template today!

Step 2: Configure the Source ( ~1 min)

1. Set up your import settings in the “Config” sheet to define the scope and timing of your Reddit Ads data pull.

• Choose the Start Date
  Decide how far back you want to fetch campaign data.

Tip: A shorter date range is recommended to ensure a faster and more reliable import.

2. Add Your Account ID(s)

• Your Reddit Ads Account ID is available on the main dashboard of your Reddit Ads account. 

Copy and paste this ID into the designated field within the spreadsheet’s configuration tab.

3. Choose Your Data Field

Go to the “Fields” tab and check the boxes of all the fields you want to import based on your reporting needs.  

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
• MaxFetchingDays: Max number of days to fetch per run 
• CleanUp To Keep Window: Automatically deletes rows older than the specified number of days from today. Leave blank to retain all rows.

Step 3: Get a Reddit Ads Access Token ( ~1 min)

To start importing data into Google Sheets, first connect to the Reddit Ads API. 

Here are the steps:

1. Visit the Reddit Preferences Page.
   Go to the Reddit Preferences page and sign in with your existing Reddit account, or create a new one if you don’t have one yet.
2. Create a new app:
   Click the Create App button.

3. Enter the App Details:

• App Name and Description
• App type: Select script
• Redirect URI: http://localhost:8080

Click Create App 

4. Once the app is created, the following details will be displayed:

• Client ID (just under the app name)
• Client Secret
• Redirect URI 

5. Now, Go to the Reddit API Access Request Form. In the form, make the following selections: 

• Choose: “I'm a Developer”
• Then select: “I want to register to use the free tier of the Reddit API”
• Under “Purpose,” pick: Other

Provide the required additional details in the form:

• Describe your tool’s purpose: Example

"We plan to use the Reddit Ads API to automatically extract advertising metrics and store them in Google Sheets and BigQuery. This data will be processed via OWOX Data Marts to support daily marketing reporting and optimization efforts."

• Add a link to the repository: https://github.com/OWOX/owox-data-marts
• Include your Reddit username

Fill in the contact information and use case details:

• Reddit API Use Case: Example

"The Reddit Ads API will be used to automate data collection from our ad account. We use OWOX Data Marts to transfer this data into Google Sheets and BigQuery for marketing analytics, allowing us to streamline reporting and improve media planning."

• Developer Platform: Google Sheets, App Script
• OAUTH Client ID(s): Paste the Client ID from your app 

Complete the final step of the request form:

• Subject of inquiry: 

Request access to the Reddit API

• Details of inquiry: Example

"Our organization intends to leverage the Reddit Ads API to access campaign-level advertising data for integration into our internal analytics workflows. Using the OWOX Data Marts platform, this data will be securely transferred to Google Sheets and Google BigQuery to support real-time performance tracking, marketing spend analysis, and strategic reporting."

• Leave the file attachment section blank.
• Click “Submit” to send your request.

7. To generate your authorization code, use the following URL format. Be sure to replace YOUR_CLIENT_ID and RANDOM_STRING with your actual values (e.g., abc123):

https://www.reddit.com/api/v1/authorize
  ?client_id=YOUR_CLIENT_ID
  &response_type=code
  &state=RANDOM_STRING
  &redirect_uri=http://localhost:8080
  &duration=permanent
  &scope=read

Paste the URL into your browser and press Enter. 

When prompted, click “Allow,” ensuring you're logged into the Reddit account associated with your ad account. 

8. Copy the code parameter

• You'll be redirected to a URL that looks like this:

http://localhost:8080/?state=xyz123&code=bLcIq0FR9-8hjOpklbxK2dtRTsA#_

• From this URL, copy the value of the code parameter – in this case, it's: bLcIq0FR9-8hjOpklbxK2dtRTsA.

9. Use Postman to exchange the authorization code for a refresh token. Set up the request as follows: 

Fill the Parameters:

• grant_type=authorization_code
• code=YOUR_CODE (from previous step)
• redirect_uri=http://localhost:8080

Auth Type: Basic Auth

• Username: Your Client ID
• Password: Your Client Secret

Set the User-Agent properly:

Use this format in your API requests: 

googleapps:owox-data-marts.redditads:v1.0.0 (by /u/your_reddit_username)

Make sure to replace /u/your_reddit_username with your actual Reddit username. For more info on best practices for User-Agent, see Reddit's API Guidelines.

Now, you have everything you need to complete the setup:

• Client ID
• Client Secret
• Redirect URI
• Refresh Token

You're now ready to connect your Reddit Ads data to Google Sheets using the OWOX template.

Step 4: Input Credentials in the Template ( ~10 seconds)

Connect your Reddit Ads credentials to the Google Sheets template:

1. Open the Credentials Panel

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

2. Grant App Script Access

When prompted:

• Click “OK” to authorize the Apps Script.
• This allows the connector to access your Google Sheet and import data from Reddit Ads. 

3. Enter Your Add Your Credentials

• Paste your Client ID, Client Secret, Redirect URI, Refresh Token, and User Agent into the form.

• Click Save.
  
  

This step activates the connector with the correct credentials.

Step 5: Run the Connector & Import Your Data ( ~1 min)

Now, you're all set to load your data.

1. Start the Import

• From the spreadsheet menu, go to: OWOX → Import New Data.

• The connector will begin importing data from your specified Reddit Ads account(s).

1. Once the process completes, check the “Logs” sheet for the message: “Import is finished.”

In this Google Sheets template, your data will appear in new tabs labeled with the corresponding data types (e.g., accounts).

‍

To add more fields later, simply open the Fields tab, select the additional checkboxes, and run:

OWOX → Import New Data

Important: To change the date range:

• Clear existing data in the Status columns
• Update the Start Date and/or End Date
• Run OWOX → Import New Data again 

📊 Real-Time Visualization with OWOX Reports

Want to bring your Reddit Ads data into Google Sheets for quick, visual reporting?

With the OWOX Reports Extension, you can turn raw Reddit Ads data into live dashboards – no SQL, no complex setup, and no Looker Studio required.

Here’s what you can do with this Reddit Google Sheets integration:
📥 Pull Reddit campaign data directly into Sheets from BigQuery
📊 Create auto-updating dashboards to track spend and performance
✅ Share real-time reports with your team – fast, flexible, and code-free

No manual exports, no scripts – just a seamless Reddit to Google Sheets connection that simplifies analysis and drives clarity.

Whether you're optimizing bids, monitoring conversions, or comparing creatives, OWOX AutoCharts makes it easy to stay on top of your Reddit Ads performance.

What’s Next?

This free Reddit to Google Sheets connector from OWOX Data Marts (Community Apps Script Edition) is built to give you full data control – no cost, no coding, no blockers.

Explore more helpful resources:

🔗 More free connectors – like LinkedIn Ads, and Microsoft Ads – so you can unify your marketing data in Google Sheets with zero switching costs
🎥 Step-by-step video tutorials – guiding you through setup, customization, and analysis with no prior coding experience
📊 Ready-to-use dashboards – helping you turn Reddit Ads data into insights in minutes, not hours

Visit our GitHub repo, give us a ⭐ star, and help us build a more open, flexible future for data analysts and marketers everywhere.

Google Sheets

Data sources

Free Reddit Ads Connector to Google Sheets

Download template