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 [email protected]
Installation
Step 1: Install the Google Apps Script
- Open a new or existing Google Sheet
- Go to Extensions → Apps Script in your Google Sheets menu
- Delete any existing code in the script editor
- Copy and paste the AdManage Google Apps Script code (contact support for access)
- Save the project with a name like “AdManage Integration”
Step 2: Initial Setup
- Refresh your Google Sheet
- You should now see an “Admanage 🚀” menu in your Google Sheets toolbar
- 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:
- When you first open the sidebar, you may be prompted to authorize the script
- Click “Review Permissions” and grant the necessary access
- 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
Get Your API Key
- Log in to your AdManage account at admanage.ai
- Navigate to your account settings or API section
- Generate or copy your API key
- Keep this key secure - you’ll need it for authentication
Connect to AdManage
Connect to AdManage
- In the Google Sheets sidebar, paste your AdManage API key
- Click “Verify Account”
- If successful, you’ll see a confirmation message with your email
- 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
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
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
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
Text Variations
- Headline Variation 1-5 - Multiple headline options
- Primary Text Variation 1-5 - Multiple body text options
Carousel Content
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
- Ensure your sheet has the proper column headers
- Fill in your ad data according to the structure above
- Save your sheet
Step 2: Upload to Launch Drafts
Start Upload Process
Start Upload Process
- Open the AdManage sidebar (Admanage 🚀 → Launch sidebar)
- The addon will automatically detect new rows that haven’t been uploaded
- Review the upload summary showing how many new rows were found
Configure Upload Settings
Configure Upload Settings
- 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
- Status: Choose the initial status for your launch draft:
- Draft - Save as draft for review (recommended)
- Active - Immediately activate the launch draft
Execute Upload
Execute Upload
- Click “Upload to Launch Drafts”
- Wait for the upload to complete
- 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
Authentication Issues
Problem: “No AdManage API key found” error
Solution:
- Verify you’ve entered your API key in the sidebar
- Check that your API key is valid by logging into AdManage
- Try logging out and reconnecting your AdManage account
- Contact support if your API key isn’t working
Sheet Format Issues
Sheet Format Issues
Problem: “Missing required columns” error
Solution:
- Ensure your sheet has a “Row Type” column header
- Check that column headers are in the first row
- Verify there are no extra spaces in column names
- Make sure you have actual data rows below the headers
Upload Failures
Upload Failures
Problem: Upload fails or times out
Solution:
- Check your internet connection
- Verify your Ad Account ID is correct
- Ensure you have permission to create launch drafts in AdManage
- Try uploading smaller batches if you have many rows
- Contact support with the exact error message
No New Rows Found
No New Rows Found
Problem: “No new rows found to upload” message
Solution:
- Check if you have an “ADMANAGE_UPLOADED_AT” column - this tracks uploaded rows
- Add new rows without timestamps in the ADMANAGE_UPLOADED_AT column
- If you want to re-upload existing rows, delete the timestamps from that column
- Ensure your new rows have data in the required “Row Type” column
Permission Errors
Permission Errors
Problem: Script authorization issues
Solution:
- Go to Extensions → Apps Script → Run function → onOpen
- Grant all requested permissions when prompted
- If permissions are denied, remove the script and reinstall
- 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
- Prepare campaigns in your preferred spreadsheet tool
- Import/paste data into your Google Sheet with proper headers
- Review and validate data before uploading
- Upload to AdManage using the addon
- 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.