The AdManage Google Sheets Addon allows you to seamlessly upload ad campaign data directly from your spreadsheets to AdManage’s Launch Drafts feature. This integration streamlines your workflow by eliminating the need to manually export and import CSV files.

Need help? For technical support, email us at [email protected]

Installation

Step 1: Install the Google Apps Script

  1. Open a new or existing Google Sheet
  2. Go to ExtensionsApps Script in your Google Sheets menu
  3. Delete any existing code in the script editor
  4. Copy and paste the AdManage Google Apps Script code (contact support for access)
  5. Save the project with a name like “AdManage Integration”

Step 2: Initial Setup

  1. Refresh your Google Sheet
  2. You should now see an “Admanage 🚀” menu in your Google Sheets toolbar
  3. Click Admanage 🚀Launch sidebar to open the integration panel

Authentication

Connect Your Google Account

The addon requires access to your Google account to function properly:

  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)

Verify Your AdManage Account

Preparing Your Sheet Data

Required Column Structure

Your Google Sheet must include the following required column:

  • Row Type - Specifies the type of ad (single, multi, carousel, etc.)

Optional Columns

The addon supports numerous optional columns for comprehensive ad configuration:

Sample Sheet Structure

Here’s an example of how your sheet should be structured:

Row TypeCustom NameTitleAd DescriptionLinkCTAHeadline Variation 1Primary Text Variation 1
singleSummer Sale AdSummer Sale 2024Get 50% off everythinghttps://example.comShop NowSummer Sale - 50% OffDon’t miss our biggest sale
multiProduct LaunchNew ProductIntroducing our latest innovationhttps://example.com/newLearn MoreRevolutionary ProductGame-changing technology

Using the Addon

Step 1: Prepare Your Data

  1. Ensure your sheet has the proper column headers
  2. Fill in your ad data according to the structure above
  3. Save your sheet

Step 2: Upload to Launch Drafts

Smart Features

Automatic Row Tracking

The addon intelligently tracks which rows have already been uploaded:

  • New rows only: Only uploads rows that haven’t been processed before
  • 📅 Timestamp tracking: Adds an “ADMANAGE_UPLOADED_AT” column with upload timestamps
  • 🔄 Incremental updates: Add new rows anytime and upload only the additions

Ad Account ID Memory

Save time with automatic Ad Account ID persistence:

  • 💾 Auto-save: Your Ad Account ID is automatically saved after successful uploads
  • 🚀 Auto-populate: The field pre-fills with your last used ID
  • Visual confirmation: See ”✓ Using saved Ad Account ID” when a saved ID is loaded
  • 🗑️ Easy reset: Click the × button to clear and use a different ID

Data Validation

Before uploading, the addon validates your data:

  • ✅ Checks for required columns
  • ✅ Validates sheet structure
  • ✅ Provides clear error messages for issues
  • ✅ Shows upload statistics and progress

Troubleshooting

Advanced Tips

Batch Processing

  • Optimal batch size: Upload 50-100 rows at a time for best performance
  • Multiple uploads: You can add new rows and upload them separately
  • Status tracking: Use the ADMANAGE_UPLOADED_AT column to track upload history

Data Management

  • Backup your data: Always keep a backup of your original sheet
  • Version control: Consider duplicating sheets before major changes
  • Column order: Column order doesn’t matter - the addon matches by header name

Integration Workflow

  1. Prepare campaigns in your preferred spreadsheet tool
  2. Import/paste data into your Google Sheet with proper headers
  3. Review and validate data before uploading
  4. Upload to AdManage using the addon
  5. Manage campaigns in the AdManage platform

Support

Having issues with the Google Sheets addon? We’re here to help:

  • 📧 Email Support: Contact our support team at [email protected] with specific error messages
  • 📚 Documentation: Check our other integration guides for additional context
  • 🔧 Technical Issues: Include your browser, Google account type, and error details

The AdManage Google Sheets addon streamlines your campaign creation workflow, letting you work in familiar spreadsheet environments while leveraging AdManage’s powerful campaign management features.