Skip to main content
The AdManage Google Sheets Addon is a comprehensive campaign management tool that brings the full power of AdManage directly into your Google Sheets environment. Upload launch drafts, export ad sets, match campaigns, and manage your advertising data all without leaving your spreadsheet. Need help? For technical support, email us at [email protected]

​
Key Features

The addon provides four core features accessible through an intuitive interface:
  • 🚀 Launch Ads - Upload campaign data to AdManage Launch Drafts
  • 📊 Export Data - Export ad sets and campaign data from AdManage to sheets
  • 🎯 Match Ad Sets - Intelligently match ads to appropriate ad sets based on campaign patterns

​
Typical Launching Workflow

  1. Setup: Use “Load Defaults” to create properly structured sheet
  2. Data Entry: Fill in columns and rows with your information
  3. Upload: Send launch batch to AdManage
  4. Launch: Complete launching in AdManage platform

​
Installation

​
Install from Google Workspace Marketplace

The AdManage addon is available directly from the Google Workspace Marketplace for easy installation: Install AdManage from Google Workspace Marketplace
  1. Open Google Sheets - Create a new sheet or open an existing one
  2. Access Extensions - Go to Extensions → Add-ons → Get add-ons
  3. Search for AdManage - In the Google Workspace Marketplace, search for “AdManage”
  4. Install the Add-on - Click on the AdManage addon and select Install
  5. Grant Permissions - Review and accept the required permissions when prompted

​
Initial Setup

  1. Refresh your Google Sheet after installation
  2. Go to Extensions → AdManage → Launch Sidebar to open the integration panel
  3. The addon will automatically attempt to authenticate with your Google account

​
Authentication

​
Connect Your AdManage Account

The addon requires authentication with both Google and AdManage:
  1. When you first open the sidebar, you may be prompted to authorize the script
  2. Click “Review Permissions” and grant the necessary access
  3. The addon needs permissions to:
    • Read and modify your spreadsheet data
    • Connect to external services (AdManage API)
    • Access your Google account information
The addon uses automatic authentication through your Google account. The email address on the google account must be invited to your admanage organization.

​
Feature 1: Launch Ads (Upload to AdManage)

Transform your spreadsheet data into AdManage Launch Drafts for campaign creation.

​
Required Column Structure

Your Google Sheet must include the Row Type column:
  • Row Type - Specifies the ad format (single, multi, carousel, etc.)

​
Supported Columns

The addon supports extensive column mapping for comprehensive ad configuration:
  • Custom Name / Ad Name - Campaign or ad identifier
  • Ad Description / Description - Detailed ad description
  • Headline / Ad Title - Primary headline text
  • Primary Text / Main Text / Body Text - Ad body content
  • Created At / Updated At - Timestamps
  • Video URLs / Video Link / File Links - Media content
  • Ad Set IDs - Target ad set identifiers
  • Launch Paused - Launch in paused state (true/false)
  • Headline Variation (1-5) - Multiple headline options
  • Primary Text Variation (1-5) - Multiple body text options
For carousel ads, the addon supports up to 10 carousel items:
  • Carousel X Media URL - Media file for each carousel card
  • Carousel X Portrait Media URL - Portrait orientation media
  • Carousel X Title - Title for each carousel card
  • Carousel X Description - Description for each carousel card
  • Carousel X Link - Destination URL for each carousel card Note: Special carousel processing is available for specific customer configurations

​
Column Mapping Intelligence

The addon includes intelligent column mapping that automatically recognizes common variations:
  • “Campaign Name” → “Custom Name”
  • “Media Type” → “Row Type”
  • “Page Link” → “Link”
  • “Call-to-Action” → “CTA”
  • And many more automatic mappings

​
Upload Process

  1. The addon automatically detects new rows that haven’t been uploaded
  2. It adds an “ADMANAGE” column to track upload status
  3. Only processes rows without timestamps in the ADMANAGE column
  4. Shows upload statistics before processing
  1. Click “Upload to AdManage” from the Launch Ads card
  2. The addon processes up to 50 rows per batch for optimal performance
  3. If you have more than 50 rows, run multiple uploads
  4. Each successful upload adds timestamps to processed rows
  • Business ID: Optional business/ad account identifier
  • Status: Choose “draft” or “active” for launch drafts
  • Automatic Title Generation: Uses row count and timestamp
  • CSV Format: Data is automatically formatted as CSV for AdManage

​
Feature 2: Export Data (Ad Sets from AdManage)

Export ad set data from your AdManage account directly into Google Sheets for analysis and management.

​
Export Capabilities

  1. Click “Export from AdManage” from the Export Data card
  2. Enter your Facebook/Meta Ad Account ID (numeric format)
  3. The addon fetches all ad sets with pagination support
  4. Creates a new sheet named “AdSets_[AccountName]”
The export includes essential ad set information:
  • Ad Set ID - Unique identifier
  • Name - Ad set name
  • Campaign Name - Parent campaign
  • Spend - Total ad spend
  • Status - Current ad set status
  • Ad Count - Number of ads in set
  • Platform - Advertising platform
  • Account Memory: Your Ad Account ID is saved for future exports
  • Last Sync Tracking: Timestamps are recorded for each export
  • Multiple Accounts: Support for managing multiple ad accounts
  • Automatic Formatting: Headers, frozen rows, and auto-resized columns

​
Background Sync & Scheduling

The addon includes advanced sync management:
  • Configured Syncs: Set up automatic synchronization schedules
  • Batch Processing: Run multiple account syncs simultaneously
  • Sync Status Tracking: Monitor sync history and status
  • Error Handling: Automatic API key refresh and retry logic

​
Troubleshooting

Problem: “No AdManage API key found” or connection failuresSolution:
  1. Use the refresh button in the account header
  2. Sign out and sign back into your Google account
  3. Check that your Google account is linked to AdManage
  4. Try opening the addon in an incognito window
  5. Ensure you have AdManage account access
Problem: “Wrong email address showing” The wrong email address is showing in the addon. This issue occurs when you have multiple google accounts in your chrome browser and the default one is the wrong one. We can’t fix this issue because it’s caused by google incorrectly telling us who is logged in.https://developers.google.com/apps-script/guides/projects#fix_issues_with_multiple_google_accountsTry one of the following solutions:
  • Log out of all your Google Accounts and only log in to the one that has the add-on or web app you want to access.
  • Open an incognito window in Google Chrome, or an equivalent private browsing window, and log in to the Google Account that has the add-on or web app you want to access.
Problem: Column mapping or data format errorsSolution:
  1. Use the “Load Defaults” feature to see proper structure
  2. Ensure “Row Type” column exists and contains valid values
  3. Check for extra spaces in column headers
  4. Verify data is in expected formats (URLs, numbers, text)
  5. Use column mapping preview to verify recognition
Problem: Upload process fails or times outSolution:
  1. Try uploading smaller batches (under 50 rows)
  2. Check internet connection stability
  3. Verify Ad Account ID format and permissions
  4. Look for error messages in the addon interface
  5. Clear and re-enter problematic data
Problem: Ad set export fails or returns no dataSolution:
  1. Verify Ad Account ID is correct and accessible
  2. Check that you have permission to view ad sets
  3. Ensure the account has active ad sets to export
  4. Try a different Ad Account ID format (with/without “act_”)
  5. Check AdManage platform for account status
Problem: Ad set matching returns poor resultsSolution:
  1. Check that campaign names follow consistent patterns
  2. Verify ad set data has been recently exported
  3. Review column detection for country, language, product fields
  4. Consider setting up custom mapping rules
  5. Ensure ad sets exist for the targeting criteria

​
Support

Having issues with the Google Sheets addon? We’re here to help:
  • 📧 Email Support: Contact our support team at [email protected]
  • 🔧 Technical Issues: Include browser type, error messages, and screenshots
  • 📚 Feature Requests: Let us know what additional functionality you need
  • 🚀 Integration Help: Assistance with complex workflow setups
The AdManage Google Sheets addon transforms your spreadsheet into a powerful campaign management hub, providing seamless integration between your data and AdManage’s comprehensive advertising platform.
⌘I