Leads Importer Docs
  • 1. Setting up your Google Account & API in Leads Importer
  • 2. How to search for listings/leads
  • 3. Adding AI descriptions to your Listings
  • 4. Setting up your website for GeoDirectory
    • 4.1 Connecting your GeoDirectory website to Leads Importer
    • 4.2 Setting up Custom Post Types in Leads Importer for GeoDirectory
    • 4.3 Setting up Categories in Leads Importer
    • 2.4 Importing Leads to your GeoDirectory website
  • 5. Setting up your website for Voxel Theme
    • 5.1 Setting up the custom fields in Voxel
    • 5.2 Setting up the application username + API and Post types and categories
    • 5.3 Installing and Setting up FlowMattic
    • 5.4 Setting up FlowMattic workflow
    • 5.5 Installing and Setting up Voxel Leadsimporter plugin
    • 5.6 Importing Leads to your Voxel website
  • 6. Setting up your Google Sheets for Leadsimporter
    • 6.1 Importing listings to Google sheets
  • 7. Common Errors + Suggestions
  • 8. Best Practices in Importing Listings
  • 9. Using the Map search*
Powered by GitBook
On this page

6. Setting up your Google Sheets for Leadsimporter

In this page we show you how to setup Google sheets and also Directify to be used with Google sheets.

Previous5.6 Importing Leads to your Voxel websiteNext6.1 Importing listings to Google sheets

Last updated 10 days ago

1. Setting up Google sheets and Leadsimporter

Create a new Google sheets, You can name it as you see fit.

  1. Go to LeadsImporter page "API Settings".

  2. If you are using "Directify", enable the toogle, if you are using only Google Sheets, skip to step 4.

  1. Add your directify website and click save.

  1. Copy the script using the "Copy to clipboard" and go to your Google sheet and navigate to "Extensions" and click "Apps script".

  1. Go to the script section and click in "Code.gs", a black canvas will appear.

  1. Add the code copied from Leadsimporter.

  1. Go back to Leadsimporter and copy the Google sheets webhook.

  1. Add it to the script in line 2 (Between the '' quotes).

  1. Save by clicking the disk icon.

  1. If you have searched for listings already and imported to the temp database, you can click the "run" icon and the Google sheet should start to populate automatically. If no listings yet, please check step:

6.1 Importing listings to Google sheets