Option 11: Set up Google Sheets as data destination for Meta Lead Ads

Video Walkthrough

Description  

The Google Sheets destination in Datahash automatically sends Meta Lead Ads data to a spreadsheet in your Google Drive. This allows for easy data tracking, sharing, and integration with other tools like Google Data Studio or BI platforms.

Prerequisites  

• A Google account with access to Google Drive.
• An existing Meta Lead Ads Source connection in Datahash.

Setup Instructions  

1. Login to Datahash
   • Go to Datahash Studio
   • Enter your credentials
2. Select Google Sheets as Destination
   • Navigate to Files category under Destinations (right section)
   • Click the Google Sheets connector tile

3. Authenticate with Google

• Click Sign in with Google
• Choose the Google account to integrate
• Grant the permissions requested by Datahash

4. Select Source & Name the Connection

• Choose Meta Lead Ads as the source type

5.Select Source & Name the Connection

• Choose Meta Lead Ads as the source type
• Select the connection name from your Source setup (Meta Lead Ads Source)
• Provide a name for this connection

6.Configure Spreadsheet Settings

• Enter the Spreadsheet Name
• Select the Folder Location in your Google Drive where the file will be stored

7.Folder & File Structure

• Datahash will automatically create:

• A folder named Datahash in your chosen location (or root Drive if none selected)
• A subfolder named after your lead ads connection
• Inside the subfolder, the Google Sheet will store all incoming leads, automatically appending new entries

7. Validate & Finish

• Click Validate Credentials
• Once validated, click Finish

• You can now view the connected instance in the Datahash dashboard

Managing Instances  

Add a New Instance  

• Click the Edit icon in Manage Connections

• Repeat the setup:
  • Select Meta Lead Ads as source type

• Enter spreadsheet name and folder location
• Click Validate Credentials
• Click Finish

• The new instance will appear in the Manage Existing Connections table

You can see the newly created instance “Ads connection 2” in the manage existing connection instances table

Editing an existing connection instance:

• Click on the connection name in the manage existing instances table to open the setup.

• Click the Edit icon (top right corner)

• Update spreadsheet name, folder location, or other fields
• Click Validate Credentials to confirm
• Click Finish to save changes
   (If you click Cancel, the existing configuration will remain active)