Video Walkthrough
Description:
Google Sheets is a widely used cloud-based spreadsheet tool that enables you to organize, analyze, and share data in real time. By integrating Google Sheets as a destination, you can automatically sync LinkedIn Lead Ads data into a structured spreadsheet, making it easier to manage leads and collaborate across teams.
Prerequisites:
- A Google account with access to Google Drive.
- LinkedIn Lead Ads source connector already configured in Datahash.
Getting Started:
- Go to Datahash Studio.
- Enter your credentials to log in.
- Navigate to Files under the Destinations list on the right section.
- Click on the Google Sheets connector tile.
Authentication & Setup
- Sign in with your Google account that you would like to integrate.
- Grant all requested permissions to allow Datahash to create and update spreadsheets.
- Grant all requested permissions to allow Datahash to create and update spreadsheets.
- Select the LinkedIn Lead Ads source type.
- Choose the connection name you want to integrate and provide a display name for it.
- This should match the connection name already configured in your LinkedIn Lead Ads source connector.
- This should match the connection name already configured in your LinkedIn Lead Ads source connector.
- Spreadsheet Configuration:
- Provide a name for the spreadsheet.
- Select the folder in your Google Drive where the file should be stored.
- Click on Validate Credentials to confirm the integration.
How the Integration Works
- During setup, a new folder named “Datahash” will be created in your Google Drive.
- If you did not select a location, the folder will be created in the root directory of your Drive.
- Inside the “Datahash” folder, another folder will be created with the name of your lead ads connection.
- The data from your LinkedIn Lead Ads source will be stored in a Google Sheet inside this folder.
- As new leads are generated, they will be automatically appended to the existing spreadsheet, ensuring a single, continuously updated source of truth.
- Once credentials are validated, click Finish to complete the setup.
- The connected instance will now be visible in your Datahash dashboard.
Managing Instances
Adding a New Instance
- Start the same setup process by selecting LinkedIn Lead Ads as the source type.
- Provide a new spreadsheet name and choose the destination folder.
- Validate credentials and click Finish.
- The new instance (e.g., “Ads connection 2”) will appear in the Manage Instances table.
Editing an Existing Instance
- In the Manage Existing Instances table, click on the connection name.
- Click the Edit icon in the top right corner to enter edit mode.
- Choose the field value/values which you would like to update.
- Click Validate Credentials to confirm changes.
- If you cancel during the edit flow, the previous configuration will remain active.
- If you cancel during the edit flow, the previous configuration will remain active.
- Click Finish to save and apply updates.
