Connect Looker to Pigment and plan from trusted metrics
Bring the metrics your business already reports on in Looker into Pigment, so FP&A and RevOps teams plan from the same figures leadership sees. Scheduled deliveries replace manual CSV exports, and data moves one way, from Looker into Pigment.

Looker
Import Looker Looks into Pigment as CSV, once or on a daily, weekly, or monthly schedule.
Category
Integration method
Best for
Forecasting · Variance analysis · Automated data refresh
What can you do with Looker and Pigment?
- Reforecast against the latest actuals. Schedule a monthly Looker delivery of actuals so FP&A updates the rolling forecast in Pigment against the most recent period.
- Compare business KPIs to plan. Bring operational metrics such as bookings or usage from a Look into Pigment and track them against your plan assumptions.
- Build next year's budget from history. Run a one-time bulk load of historical Looker data and use it as the baseline for your budget model in Pigment.
- Keep the monthly reporting pack current. Filter a Look to new or modified rows and deliver it on a recurring schedule, so your Pigment reports reflect the latest Looker data without a full reload.
How the Looker integration works
You download a sample of the Look as CSV, use it to create an import configuration in Pigment, and generate an Import API key. In Looker, you then create a Delivery that sends the Look as CSV by webhook to Pigment's dedicated Looker endpoint, using the configuration ID and key.
Deliveries run once or on a daily, weekly, or monthly schedule. Recurring schedules require permission from your Looker admin to schedule dashboards and Looks, and they appear on Looker’s Schedules page. Data flows one way, from Looker into Pigment, and you can confirm each import in Pigment's update history panel.
Key capabilities
- Choose exactly what Pigment receives. The Look you deliver defines the data, so you set fields and filters in Looker before anything reaches your model.
- Map once, reuse every run. Each delivery points to an import configuration ID, so Pigment applies the same setup every time new data arrives.
- Control access with a dedicated key. Deliveries authenticate with a Pigment Import API key, which a Workspace Admin or Security Admin generates from the API Keys management page in Pigment.
- Match the cadence to your cycle. Send a one-time delivery for an ad hoc load, or schedule deliveries daily, weekly, or monthly.
- Keep automation under admin control. Recurring schedules depend on Looker admin permission to schedule dashboards and Looks, so IT decides who can automate deliveries.
- Confirm every import landed. Check Pigment's update history panel to see each Looker delivery arrive before you build on the data.
Frequently Asked Questions
How does Looker authenticate with Pigment?
With a Pigment Import API key, generated from the API Keys management page in Pigment. You add the key and your import configuration ID to the webhook URL in your Looker Delivery.
What data can I send from Looker to Pigment?
You can send Looks, delivered as CSV through a Looker webhook Delivery. Each Look connects to an import configuration you create in Pigment.
Is there a limit on how much data Looker can send to Pigment?
Yes. Looker deliveries are limited to 5,000 rows. For larger datasets, run a one-time bulk load of historical data first, then deliver only new or modified rows on a recurring schedule.
How often can Looker send data, and who can schedule it?
Deliveries run once or on a daily, weekly, or monthly schedule. Recurring schedules require your Looker admin to grant permission to schedule dashboards and Looks.
How does this reduce manual exports for FP&A?
Each scheduled delivery replaces the download-and-upload routine for that Look. Once it’s set up, FP&A gets refreshed Looker data in Pigment on the cadence you choose, without requesting a new pipeline from IT.
Can FP&A plan with Looker metrics without opening Looker?
Yes. Once a delivery is set up, the data lands in Pigment, where FP&A can forecast and report on it and confirm each import in the update history panel.
Related integrations
See Pigment in action
The fastest way to understand Pigment is to see it in action. Sign up today and explore how agentic AI can transform the way you plan.

From 8 days to 4 min
Update P&L actuals & financial forecasting
80%
Time cut on data aggregation
12 hours
Saved per month on executive reporting
6 days faster
For scenarios creation and analysis