1. Home
  2. Docs
  3. Snapchat Lead Generation Ads
  4. Step 2: Set up data destinations for Snapchat Lead Generation Ads
  5. Option 4 – Set up MS Excel 365 as data destination for Snapchat leads

Option 4 – Set up MS Excel 365 as data destination for Snapchat leads

Description  :

Excel is a spreadsheet program from Microsoft and a component of its Office product group for business applications. Microsoft Excel enables users to format, organize and calculate data in a spreadsheet.

Prerequisites:  

  • Microsoft account.

Getting Started:  

  • Go to https://studio.datahash.com/login
  • Enter your credentials to log in
  • Navigate to Files category under Destinations list in the right section.
  • Click on the “Microsoft Excel” connector tile

Sign in with your Microsoft account, which you would like to integrate.

∙ Select the Snapchat Lead Generation Ads source type.

Now select the connection name you want to integrate and provide a name to it. This is the same connection name you have already connected in the Source connector (Snapchat Lead Generation Ads Source).

Provide a name for the spreadsheet and select the folder where you would like to receive the file.

Once done, click on Validate credentials to proceed. The file path will be displayed to let the user know where the file will be created.

During the setup process, a new folder named ‘Datahash’ will be created. This folder will be placed in the location you’ve selected, or directly in your drive if no specific location was chosen.

Inside the ‘Datahash’ folder, we’ll create another folder named after your lead ads connection. This is where your data spreadsheet will be stored. As new data comes in, it will be automatically appended to the existing spreadsheet for the lead ad source connection you selected during setup.

This ensures all your data stays organized in one place, making it easy to access and analyze.

Once the connection is verified, click “Finish” to complete the setup.

You can access the set-up again by clicking on the edit button in the MS Excel connector widget.

The set-up configurations can be edited if required, from the Manage connections section.

How can we help?