A dashboard needs to be created in Looker Studio.

Budget: 4000 UAH Deadline: 5 days

👋 Hello!😄

This is exactly my profile — Google Apps Script + API + Google Sheets + Looker Studio.

🛠 How I will do it:
• Google Cloud service account + connection to Google Business Profile API.
• Apps Script: daily trigger (03:00) → requests to GBP API for all locations of the network → recording in Google Sheets (as a database).
• Indication of the last update date, error handling, and API limits.
• Dashboard in Looker Studio based on the table: branch performance metrics, filters, visualizations.

Clean code, documentation, configured trigger. I will clarify the list of metrics — and will deliver it turnkey.

🎥 Portfolio: Freelancehunt

Feel free to reach out! Expand

Budget: 5000 UAH Deadline: 5 days

Good day! I create exactly these connections: I pull Google API through Apps Script into a Spreadsheet, and on top, I build a dashboard in Looker Studio. I will set up a service account in Google Cloud, attach a nightly trigger that collects metrics for each location into a flat table with an update date, and I will create cards with dynamics and sparklines as in your specifications. How many locations do you have, and do you already have access to the Business Profile API — this will affect the timeline?

Budget: 5000 UAH Deadline: 5 days

Hello. I have experience with Google Apps Script/Google APIs. I am ready to collaborate.

Budget: 4000 UAH Deadline: 3 days

Good day.

The category of databases and SQL is not quite accurate. For this project, the categories of data analytics, working with APIs, or automation are much more suitable, as instead of classic databases, you will be using Google Sheets and Google Apps Script.

I am ready to develop a dashboard for you in Looker Studio with full automation. I have significant experience integrating the official Google Business Profile API.

What exactly I will do:

I will set up a service account in Google Cloud for secure authorization.

I will write an Apps Script that will collect all necessary metrics for the previous day for each branch every night at 03:00.

I will organize the correct recording of data in Google Sheets in a flat format linked to the date and location ID.

I will create a visually understandable dashboard with all the specified key performance indicator cards.

I will set up percentage dynamics indicators and corresponding colored Sparkline graphs for views, calls, clicks, routes, ratings, and new reviews.

I am ready to start working immediately after discussing the details of access to your company profile. Expand

Budget: 5000 UAH Deadline: 5 days

Hello! I will build this dashboard for you turnkey — I have done similar connections with Apps Script + Google API + Looker Studio, so the entire pipeline from the service account to the metric cards is familiar to me.

Here’s how I see the implementation:
— a service account in Google Cloud with access to the Business Profile API;
— an Apps Script with a daily trigger at 03:00 that pulls yesterday's metrics for each locationId: Impressions (Search+Maps), calls, Website Clicks, Direction Requests, average rating, new reviews;
— recording in Google Sheets in a flat format (row = Date + Branch ID + metrics), the table as a base for Looker;
— a dashboard in Looker Studio: 6 cards with % dynamics and sparkline in your colors, plus an indication of the last update date.

One clarification, as this is often a bottleneck: the Business Profile API is granted by quota, which Google approves for a specific project upon the application of the location owner. Do you already have access to the GBP API, or does this also need to be arranged? This affects whether we start immediately. And how many locations are we approximately talking about?

At the start, I am taking the initial price — I am gathering my first reviews on Freelancehunt, so I am offering a good deal: about 5000 UAH, 5 working days.

I am ready to show live demos of similar integrations so you can see the approach before the decision.

Petro Pankov, BotCraft Group Expand

Budget: 5500 UAH Deadline: 6 days

Good day, Mykhailo!

The combination from your terms of reference — Google Business Profile API + Apps Script + Google Sheets + Looker Studio — is exactly my profile; I create such pipelines for data collection and visualization.

How I will execute it:
1. Service account in Google Cloud, connecting Business Profile Performance API (Impressions Search/Maps, Website Clicks, Direction Requests, calls) and Reviews API (average rating, new reviews).
2. Apps Script with a trigger at 03:00: daily retrieves metrics for each locationId and writes them to the Sheet in a flat format (Date + Branch ID + metrics), with an error log and a mark of the last update.
3. Looker Studio: 6 KPI cards with sparklines in your colors, dynamics in percentages (for rating — absolute, +0.1), filters by branch and period, data freshness indicator.

An important nuance from practice: the Performance API returns statistics with a delay of 2-3 days — "for yesterday" Google does not show it immediately. Therefore, the script will retrieve data with a shift, and this will be correctly marked on the dashboard so that the numbers are always complete, without gaps.

A live example of working with data and visualization: guardlabs.online/tools/analytics/ — our own web analytics tool.

A few clarifications: how many branches are in the network, has access to the GBP API in your Google Cloud already been approved (Google issues a quota upon request — I can arrange it), and is period comparison needed (week to week / month to month)?

I work through Safe, in writing, with demo intermediate stages. Expand

Budget: 6400 UAH Deadline: 7 days

Good day! I have done a nearly identical task: daily automatic export from Google Search Console API for dozens of websites — service account in Google Cloud, scheduled trigger, pagination, recording in a flat table (date + object + metrics). Your scheme with GBP API is exactly the same, just the metrics are different.

What I will do:
— a script (Apps Script) with a trigger at 03:00, which pulls metrics for yesterday for each locationId into Google Sheets;
— an indicator of the last update date + API error handling;
— a dashboard in Looker Studio: cards for Impressions, calls, clicks to the site, routes, ranking, and new reviews — with dynamics % and sparklines, as in the specifications.

Portfolio: automatic Looker Studio dashboards + exports from Google API (examples in the profile). I work through Safe.

Deadline: 5–7 days.

Budget: 8000 UAH Deadline: 7 days

Good evening. I can set up data collection from the Google Business Profile API via Google Apps Script, daily updates to Google Sheets, and create a dashboard in Looker Studio with metric cards, dynamics, and filters by branches. Please clarify:
1. How many locations need to be connected?
2. For what period should historical data be loaded?
3. With which previous period should the metrics be compared: the previous day, week, or the same period?
4. What filters are needed in the dashboard: date, branch, city, region?
5. Is access to Google Cloud, GBP, Google Sheets, and Looker Studio already available?
6. Do you need to additionally set up notifications for errors or the absence of daily updates?

Budget: 6500 UAH Deadline: 7 days

Good day, Mykhailo. I will build the connection GBP API → Google Apps Script → Google Sheets → Looker Studio according to your reference. Data will be recorded via upsert using the key "date + locationId," so a repeated run will not create duplicates; I will add a daily trigger, error log, and date of the last successful update. In Looker, I will set up filters for period/branch, KPIs, dynamics, sparklines, and location comparisons. Initially, I will separately check access to the Business Profile API and the correct method of authorization, as this depends on the rights of the GBP account. I need the number of branches and Google Business Profile admin access.

Budget: 4000 UAH Deadline: 5 days

Hello! Right away, an important point about the structure: your six metrics come from two different APIs, not one. Views, calls, website visits, and routes are from the Business Profile Performance API, while the average rating and new reviews exist separately in the reviews API. Therefore, I will create the script using two sources; otherwise, the rating and review cards would simply remain empty. I will consolidate everything into a flat table: row = date + locationId + metrics, as you described, and Looker Studio will read this as a ready database.

Apps Script with a trigger at 03:00, fetching metrics for yesterday for each location, indicating the date of the last update, Google Cloud service account, sparkline, and dynamics for each card in the required colors.

One point worth noting in the timeline: access to the GBP API from Google is not granted instantly; the project needs to be submitted for approval, which can sometimes take a few days. If you already have access, we can start immediately. I am ready to discuss. I look forward to collaborating.

Budget: 4000 UAH Deadline: 4 days

Hello. I will set up daily retrieval of metrics from the Google Business Profile API, record them in Google Sheets in a flat format, and create a Looker Studio dashboard with KPIs, dynamics, and update dates.

I have experience with APIs, Google Cloud, automation tasks, SQL, and monitoring dashboards. I will separate the data collection logic from the visualization to make it easy to verify and expand.

How many locations need to be connected in the first version?

Budget: 7000 UAH Deadline: 7 days

Hello! The main challenge of this dashboard is not just to extract numbers, but to properly set up authorization through GCP Service Account and design the perfect "flat" database structure in Google Sheets so that Looker Studio renders sparklines and dynamics (as in your layout image_4d7988.jpg) instantly and without aggregation errors.

I will implement this Data pipeline through an optimized Google Apps Script, which will collect metrics from the Google Business Profile API every night at 03:00 via a cron trigger, validate them, and write new rows (Date + Branch ID + Metrics) into your table. If the network of locations is large, I can deploy this process in Python (via a Docker container), which will ensure higher speed and bypass Apps Script timeouts.

I have extensive experience in automating business processes and working with APIs: I designed and developed the architecture and backend of the logistics platform MKSDelivery with tight integration of Google services (especially Google Maps) entirely on my own, "turnkey." I also work officially (as a sole proprietor of the 3rd group), which makes it easy to formalize cooperation through a B2B contract.

Budget: 4000 UAH Deadline: 4 days

Hello! I will create a complete chain: a Google Cloud service account with access to the GBP API, an Apps Script with a trigger at 03:00 that daily pulls metrics for yesterday for each locationId (Impressions Search+Maps, calls, clicks to the website) and writes to a Google Sheet in a flat format Date + Branch ID + metrics. In Looker Studio - indicator cards with sparklines and dynamics in %, filters by branches and periods, indication of the last update date. I will provide access, documentation for the script, and instructions on how to add new locations.

Budget: 9500 UAH Deadline: 6 days

Hello!

Your technical task and design layout for the dashboard have been executed at an exceptionally high level. I specialize in working with Google API, developing automations on Google Apps Script, and building interactive reports in Looker Studio. I am ready to implement this project turnkey.

The architecture you proposed (Google Cloud Service Account + Apps Script + Google Sheets as a database) is the most stable and cost-effective solution for monitoring Google Business Profile (GBP), as you will not depend on paid third-party connectors.

Here is my detailed plan for the technical implementation of your task:

1. Setting up Google Cloud and API access:
• I will create and configure a service account in Google Cloud Console.
• I will connect the necessary APIs for working with business profiles (Google Business Profile API / Business Profile Performance API).
• I will set up secure authentication for the script to work without the need for constant manual token updates.

2. Developing Google Apps Script and the database in Google Sheets:
• I will write an optimized script in JavaScript (Apps Script), integrated into your Google Sheet.
• I will set up a daily trigger (time trigger at 3:00 AM) that will automatically send requests to the GBP API.
• The script will retrieve daily metrics for the previous day for each branch separately by its LocationId.
• Data will be recorded in a flat format (Date + Branch ID + Metrics) in a separate archive tab, which will serve as the database for Looker Studio. This will ensure high report performance.
• I will add an indication of the date and time of the last successful data update in the table and on the dashboard.

3. Building the dashboard in Looker Studio:
• I will fully reproduce the design and structure from your layout.
• I will set up key metrics cards with colored Sparklines (mini-graphs of dynamics) and automatic calculation of percentage change compared to the previous similar period.
• I will add convenient interactive filters (by branches, cities, and categories).
• I will build all necessary visualizations: interaction dynamics graphs, a pie chart of view sources, a heat map of the most active times, and a detailed comparison table of branch performance.

I guarantee clean script code with error handling (for example, if the API is temporarily unavailable) and perfect visual alignment of the dashboard with your reference.

I am ready to start discussing the details and setting up Google Cloud. Please message me privately; I would be happy to collaborate! Expand

Budget: 3000 UAH Deadline: 2 days

Hello! I have experience creating similar dashboards. I offer a loyal price and quality work. Feel free to write)

Budget: 5000 UAH Deadline: 5 days

Hello!

It's an interesting task, and I'm ready to take on its implementation. I have been working with Google Apps Script and data automation for a long time, so the structure "API -> Spreadsheet -> Looker Studio" is completely clear to me.

Here's how I will do it:

Setup: I will create a service account and configure access rights to the API. If verification of the quota is needed, I will help with the application process.

Data Collection: I will write a script that will extract location statistics at 03:00 and record it in a "flat" format spreadsheet. This is an ideal base for the proper functioning of Looker Studio.

Visualization: I will build a dashboard in Looker Studio according to your specifications: KPI cards, sparklines, dynamics, and data relevance indicators.

A couple of technical questions:
— How many branches are approximately in the network? (This is important for setting up loops in the script to avoid hitting API limits).
— Is the project already set up in Google Cloud, or should everything be done from scratch?

I write transparent code that you will be able to easily maintain in the future. Expand

Budget: 5000 UAH Deadline: 5 days

The task is to automatically collect metrics from Google Business Profile for each branch, compile them into Google Sheets, and build a live dashboard in Looker Studio.

Here’s how I will do it: a Google Cloud service account with OAuth2 connects to the GBP API (mybusiness/v4 or Business Profile Performance API), an Apps Script trigger at 03:00 daily pulls metrics for yesterday for each locationId and writes rows in Sheets in the format Date + LocationId + all 6 metrics. Looker Studio connects to this table as a data source, where for each card I create a Scorecard comparing to the previous period and a Sparkline through Time Series with color coding according to the specifications. The date of the last update is displayed as a separate field with MAX(Date).

How many locations are in the network, and is there already a Google Cloud service account, or are we starting from scratch?

Budget: 8500 UAH Deadline: 6 days

1. Set up Google Cloud and Service Account to work with the Google Business Profile API.

2. Implement a Google Apps Script that will automatically retrieve statistics for all locations daily and record them in Google Sheets.

3. Build a Looker Studio dashboard with KPI cards, sparklines, date and location filters, and an indication of the last update.

I noticed that the most important point is to correctly configure access to the Google Business Profile API and the structure of the table to avoid issues with automatic updates and scaling in the future.

I already have examples of dashboards in my profile, so I understand well how to build user-friendly analytics and organize data for Looker Studio.

If the Google Business Profile is already set up and there is access to the account, we can discuss the details and immediately move on to implementation. Expand

Budget: 3000 UAH Deadline: 3 days

Hello! I am ready to complete your task, I have experience working on similar projects.

Budget: 3500 UAH Deadline: 3 days

Good day. I have reviewed the specifications. This is quite close to the tasks I have recently completed. I have worked with Looker Studio, Google Analytics, Google Ads, and dashboards with KPIs, so I understand how to properly organize data and create convenient visualizations. I will be able to implement all necessary metric cards, dynamics, and reporting. If needed, I can also suggest a few improvements for usability. I am ready to discuss the details.

Budget: 8000 UAH Deadline: 5 days

Hello! I have experience working with Google Apps Script and API integration, including the Google Business Profile API. I am ready to implement automated data collection for you: I will set up a service account, write a script for daily metric exports to Google Sheets, and connect it to Looker Studio for visualization. I have experience with flat data structures for accurate representation of dynamics and sparklines. I am ready to discuss the details, feel free to write.

Budget: 4000 UAH Deadline: 2 days

Good day! I am ready to create such a dashboard in a couple of days with high quality!! Feel free to contact me!!!!