Ad Launching
AdManage Google Sheets Addon
Complete campaign management directly from Google Sheets with launch drafts, ad set exports, matching, and data synchronization
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
- Setup: Use “Load Defaults” to create properly structured sheet
- Data Entry: Fill in columns and rows with your information
- Upload: Send launch batch to AdManage
- 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- Open Google Sheets - Create a new sheet or open an existing one
- Access Extensions - Go to Extensions → Add-ons → Get add-ons
- Search for AdManage - In the Google Workspace Marketplace, search for “AdManage”
- Install the Add-on - Click on the AdManage addon and select Install
- Grant Permissions - Review and accept the required permissions when prompted
Initial Setup
- Refresh your Google Sheet after installation
- Go to Extensions → AdManage → Launch Sidebar to open the integration panel
- 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:Google Account Authorization
Google Account Authorization
AdManage API Authentication
AdManage API Authentication
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:Basic Ad Information
Basic Ad Information
- 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
Links and Tracking
Links and Tracking
- Link / Landing Page / URL / Website - Destination URL
- Display Link - URL shown in ad
- UTM / UTM Parameters - Tracking parameters
- CTA / Call to Action / Button Text - Call-to-action text
- Partnership Code - Partnership tracking
Media and Targeting
Media and Targeting
- Video URLs / Video Link / File Links - Media content
- Ad Set IDs - Target ad set identifiers
- Launch Paused - Launch in paused state (true/false)
Multiple Variations
Multiple Variations
- Headline Variation (1-5) - Multiple headline options
- Primary Text Variation (1-5) - Multiple body text options
Carousel Content (Advanced)
Carousel Content (Advanced)
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
Smart Row Detection
Smart Row Detection
- 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
Batch Upload (Max 50 rows)
Batch Upload (Max 50 rows)
- 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
Upload Configuration
Upload Configuration
- 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
Ad Set Export
Ad Set Export
- 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]”
Exported Data Columns
Exported Data Columns
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
Sync Management
Sync Management
- 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
Authentication Issues
Authentication Issues
Problem: “No AdManage API key found” or connection failures Solution: 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
Sheet Format Issues
Sheet Format Issues
Problem: Column mapping or data format errors Solution: 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
Upload Failures
Upload Failures
Problem: Upload process fails or times out Solution: 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
Export Issues
Export Issues
Problem: Ad set export fails or returns no data Solution: 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
Matching Problems
Matching Problems
Problem: Ad set matching returns poor results Solution: 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