AdManage Google Sheets Addon

Upload launch draft data directly from Google Sheets to AdManage with our powerful Google Apps Script integration

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 [e-mail]

Installation

Step 1: Install the Google Apps Script

1. Open a new or existing Google Sheet
2. Go to Extensions → Apps 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

Get Your API Key

1. Log in to your AdManage account at admanage.ai
2. Navigate to your account settings or API section
3. Generate or copy your API key
4. Keep this key secure - you’ll need it for authentication

Connect to AdManage

1. In the Google Sheets sidebar, paste your AdManage API key
2. Click “Verify Account”
3. If successful, you’ll see a confirmation message with your email
4. Your API key is securely stored for future use

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:

Basic Ad Information

• Custom Name - Custom name for the ad
• Description - Ad description
• Title - Ad title
• Ad Description - Detailed ad description
• Created At - Creation timestamp
• Updated At - Last update timestamp

Links and UTM Parameters

• Link - Destination URL
• Display Link - Display URL shown in ad
• UTM Parameters - Tracking parameters
• CTA - Call-to-action button text
• Partnership Code - Partnership tracking code

Media and Targeting

• Video URLs - Video content URLs (comma-separated)
• Ad Set IDs - Target ad set IDs (comma-separated)
• Launch Paused - Whether to launch ads in paused state (true/false)

Text Variations

• Headline Variation 1-5 - Multiple headline options
• Primary Text Variation 1-5 - Multiple body text options

Carousel Content

For each carousel item (1-10):

• Carousel X Media Name - Media file name
• Carousel X Portrait Media - Portrait media file name
• Carousel X Title - Carousel card title
• Carousel X Description - Carousel card description
• Carousel X Link - Carousel card destination URL

Sample Sheet Structure

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

Row Type	Custom Name	Title	Ad Description	Link	CTA	Headline Variation 1	Primary Text Variation 1
single	Summer Sale Ad	Summer Sale 2024	Get 50% off everything	https://example.com	Shop Now	Summer Sale - 50% Off	Don’t miss our biggest sale
multi	Product Launch	New Product	Introducing our latest innovation	https://example.com/new	Learn More	Revolutionary Product	Game-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

Start Upload Process

1. Open the AdManage sidebar (Admanage 🚀 → Launch sidebar)
2. The addon will automatically detect new rows that haven’t been uploaded
3. Review the upload summary showing how many new rows were found

Configure Upload Settings

1. Ad Account ID: Enter your Meta/Facebook Ad Account ID
   • The addon remembers your last used Ad Account ID for convenience
   • Look for the ”✓ Using saved Ad Account ID” indicator
2. Status: Choose the initial status for your launch draft:
   • Draft - Save as draft for review (recommended)
   • Active - Immediately activate the launch draft

Execute Upload

1. Click “Upload to Launch Drafts”
2. Wait for the upload to complete
3. Upon success, you’ll see:
   • Confirmation message with upload details
   • New “ADMANAGE_UPLOADED_AT” column with timestamp
   • Your Ad Account ID saved for future use

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

Authentication Issues

Problem: “No AdManage API key found” error

Solution:

1. Verify you’ve entered your API key in the sidebar
2. Check that your API key is valid by logging into AdManage
3. Try logging out and reconnecting your AdManage account
4. Contact support if your API key isn’t working

Sheet Format Issues

Problem: “Missing required columns” error

Solution:

1. Ensure your sheet has a “Row Type” column header
2. Check that column headers are in the first row
3. Verify there are no extra spaces in column names
4. Make sure you have actual data rows below the headers

Upload Failures

Problem: Upload fails or times out

Solution:

1. Check your internet connection
2. Verify your Ad Account ID is correct
3. Ensure you have permission to create launch drafts in AdManage
4. Try uploading smaller batches if you have many rows
5. Contact support with the exact error message

No New Rows Found

Problem: “No new rows found to upload” message

Solution:

1. Check if you have an “ADMANAGE_UPLOADED_AT” column - this tracks uploaded rows
2. Add new rows without timestamps in the ADMANAGE_UPLOADED_AT column
3. If you want to re-upload existing rows, delete the timestamps from that column
4. Ensure your new rows have data in the required “Row Type” column

Permission Errors

Problem: Script authorization issues

Solution:

1. Go to Extensions → Apps Script → Run function → onOpen
2. Grant all requested permissions when prompted
3. If permissions are denied, remove the script and reinstall
4. Ensure you’re using the same Google account for both Sheets and AdManage

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 [e-mail] 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.

Assistant

Responses are generated using AI and may contain mistakes.