Spreadsheets & reporting
Looker Studio integration
Load GraftPal data into Google Sheets with your API key, then use it as a Looker Studio source for free dashboards you can share with anyone.
- Category
- Spreadsheets & reporting
- Status
- Available
- Connection
- Via GraftPal API
- Plans
- Scale plan
What it is
What is Looker Studio?
Looker Studio (formerly Google Data Studio) is Google's free tool for building dashboards and reports from sources such as Google Sheets, Analytics and BigQuery.
- Free with a Google account
- Drag-and-drop report builder
- Share links or embed dashboards
- Blends data from many sources
What it does
What Looker Studio does with GraftPal
Client-facing reports
Share a dashboard of jobs delivered and invoices paid with a client or partner.
Owner dashboard
Revenue, pipeline and jobs on one page you can check on your phone.
Blend with marketing data
Put lead sources next to your Google Ads or Analytics data.
Always current
When the sheet refreshes, the dashboard does too.
How it works
How Looker Studio works with GraftPal
An Apps Script keeps a Google Sheet filled from the GraftPal API; Looker Studio reads the sheet.
GraftPal
Looker Studio
- Google Sheets
- Looker Studio reports
How to connect
Connect Looker Studio in 4 steps
API access is part of the Scale plan. On Scale you can create API keys and connect Looker Studio; Starter and Growth workspaces can upgrade at any time.
- 1
Create a GraftPal API key
On the Scale plan, go to Settings → API keys in GraftPal and choose Create API key. Give it a name you will recognise, copy the key and keep it somewhere safe. Keys are read-only and belong to one workspace; you can delete one at any time to cut off access.
- 2
Fill a Google Sheet
Follow the Google Sheets setup to pull the data you need into a sheet on a timer.
- 3
Add it to Looker Studio
In Looker Studio, create a report and choose Google Sheets as the data source, then pick your sheet and tab.
- 4
Build and share
Add charts and scorecards, set the date range controls, and share the report link.
API keys are read-only and belong to one workspace. You can see and delete them in Settings → API keys, and access stops the moment a key is deleted.
Related integrations
Teams using this also connect
AvailableVia GraftPal APIGoogle Sheets
Pull live leads, jobs, invoices and payments into a Google Sheet that refreshes itself.
See the Google Sheets integration
AvailableVia GraftPal APIPower BI
Build Power BI dashboards on live GraftPal revenue, job and lead data.
See the Power BI integration
AvailableVia GraftPal APIMicrosoft Excel
Load GraftPal data into Excel with Power Query and refresh it with one click.
See the Microsoft Excel integrationFrequently Asked Questions
Looker Studio integration FAQ
Ready to Run Your Business From One AI-Powered Platform?
Join thousands of freelancers, consultants, and service businesses who replaced their tool stack with GraftPal. One platform. One login. Everything connected, with AI built in.