Print

Import Quora Ads Data to Google Sheets

In this guide, we’ll walk through how to pull Quora ad data directly into Google Sheets, using the API Connector add-on for Sheets.

Contents

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Connect to the Quora Ads API

The easiest way to get started with the Quora Ads API is through API Connector’s built-in integration.

  1. Select Quora Ads from the drop-down list of applications
    quoraads-application
  2. Under Authorization, click Connect to Quora Ads
    quoraads-authorization
  3. You will be taken to Quora.com and asked to provide API Connector with read access to your Quora Ads Manager data. Click Accept.
    quora-ads-img3
  4. You will now be returned to your Google Sheet, and can verify that your Quora Ads connection is active.

Part 2: Pull Data from Quora Ads to Sheets

Now that we’re connected, let’s pull some data into Sheets.

  1. Under Endpoint, choose /accounts/{account_id} to get data for your account.
    quoraads-endpoints
  2. Fill in the account_id parameter. To get your account ID, run a request to the /accounts/ endpoint, or log in to your account and check under your account name in the right-hand corner:
    quora-ads-img8
  3. Fill out the other required parameter, presetTimeRange.
  4. Select a destination sheet, name your request, and click Run.
    quoraads-response

Part 3: Create a Custom API Request

Alternatively, you can create a custom request instead of using API Connector’s built-in integration, using any of the endpoints and parameters shown in the API documentation. Here's an example request setup, just substitute in your own account ID where it says your_account_id:

  • ApplicationCustom
  • MethodGET
  • Request URLhttps://api.quora.com/ads/v0/accounts/your_account_id
  • OAuthQuora Ads


quora-ads-results

Part 4: Handle Pagination

Note that Quora Ads limits the number of records returned in each request. By default, only 25 records will be returned unless you follow the paging links to subsequent records as described in their documentation.

To retrieve more than 25 records, you would run your second request using the next page link returned in the response under the field header paging.next. With API Connector, you can loop through these requests automatically with pagination handling, like this:

  • Pagination: next page URL
  • Next page path: paging.next
  • Run until: choose when to stop fetching data
    quora-ads-pagination-nextpageurl

Part 5: Handle Quora Timestamps

For a few endpoints, Quora responds with UNIX timestamps, for example the creation_time field returned by the /recent-leads endpoint.

To convert these timestamps to a human-readable date, you have 2 options:

METHOD 1:

  1. Open the field editor by clicking Edit fields
  2. Find the timestamp fields and click the code icons
  3. In the dropdown formula menus, select the "UNIX SECONDS TO DATE" option. It will automatically populate with Google's EPOCHTODATE formula
  4. Click OK and then Save fields
  5. Run the request and the output will automatically show the timestamps as human-readable dates.

METHOD 2:

You can use the following formula (assuming their UNIX timestamps are in column D). It's an array formula so you just need to enter it once to apply to the whole column.

=arrayformula(((D1:D)/86400)/1000000+date(1970,1,1))

Part 6: API Documentation

Official API documentation: https://www.quora.com/ads/api9169a6d6e9b42452d500a61717d87d15d5fa49ec5b53030741178130#section/Overview

Leave a Comment

Jump To