Want to automate client reporting or archive key Google Business Profile (GBP) metrics? This guide walks you through how to pull data from Local Dominator using our API and send it to a Google Sheet using Make.com (formerly Integromat). You can also use Zapier or similar tools!
Step-by-Step Setup
1. Grab the Location ID
•In Local Dominator, click the Share button on the map listing.
•Copy the Location ID (found at the end of the shared URL).
2. Set Up Your Scenario in Make.com
• Click “Create a new Scenario”.
•Add an HTTP module:
• Select Make a request.
•Paste in the API endpoint (you’ll need your Location ID).
•endpoint:
https://app.localdominator.co/statistics-dashboard/share/dashboard/{Location-ID}/dashboardInfo
• Make sure Parse Response is set to Yes.
3. Run the API Call
•Hit Run once to make sure it pulls the correct data.
•You’ll see a preview of the business data, like:
•Business name
•Address
•Phone number
•Google Maps CID
•Statistics like call counts
4. Send Data to Google Sheets
• Add a Google Sheets module:
• Choose “Add a row”
•Connect to your spreadsheet and pick the correct Sheet name.
•Map the API response data to the columns in your sheet.
5. Schedule Your Automation
•Want this to run automatically?
•Set a scheduler (e.g., every Monday or on the 30th of each month).
•Great for monthly or weekly client reports!
Example Use Case
You can build a report showing:
•Number of calls per month
•Directions requests
•Website clicks
Everything updates automatically into your Google Sheet for easy sharing or client access.