Skip to main content

Google Sheets Integration

Pull IQM reporting data directly into Google Sheets for easy data analysis and collaboration.

Prerequisites​

Before using the IQM Reports Google Sheets integration, you must have:

  • An active IQM account with API access
  • A Google account with access to Google Sheets

Install the Add-on​

  1. Visit the IQM Google Workspace Marketplace Listing
  2. Click Install to add the IQM add-on to your Google account
  3. Follow the prompts to authorize the installation

Authorize Your IQM Account​

Step 1: Open the Add-on​

  1. Open a Google Spreadsheet
  2. Navigate to Extensions > IQM — Vertical Specific Advertising > Launch
note

The add-on is located in the Extensions menu at the top of Google Sheets. If you don't see "IQM — Vertical Specific Advertising" listed, make sure you've installed the add-on from the Google Workspace Marketplace.

Step 2: Select Your Google Account​

Select your Google account in the "Choose an Account" popup.

Step 3: Grant Access​

When prompted, click Allow to allow the connector to connect to your Google account.

Generate IQM Reports​

Step 1: Launch the Integration​

  1. Navigate to Extensions > IQM — Vertical Specific Advertising > Launch

Step 2: Enter Your Credentials​

  1. In the sidebar click Authorize
  2. This will open a new page where you can enter your IQM account credentials (email and password)
  3. Once entered the screen will display: "The script completed but did not return anything."
  4. Return to Google sheets

Step 3: Select Customer​

Select the Customer for which you want to generate reports.

Step 4: Configure Report Parameters​

Select your Parameters and then click Generate Report:

  • Timezone: The timezone for date interpretation
  • Start Date: Beginning of the reporting period
  • End Date: End of the reporting period
  • Dimensions: How data should be grouped (Campaigns, Creatives, etc.)
  • Metrics: The performance metrics to include (Impressions, Clicks, CTR, etc.)

Key Features​

  • Real-time data sync: Pull live Campaign data directly into your spreadsheets
  • Custom queries: Filter and select specific metrics and dimensions
  • Collaborative analysis: Share insights with team members in real-time
  • Flexible reporting: Choose your own dimensions and metrics for custom reports

Additional Resources​

Have a question?
Ask the Community
Was this page helpful?