Looker + Salesforce
Connect Looker and Salesforce to Turn Data Insights Into Sales Action
Push analytics from Looker straight into Salesforce so your revenue teams can act on current data, not last week's exports.
Why integrate Looker and Salesforce?
Looker and Salesforce do different jobs well. Looker pulls analytical insights from across your business; Salesforce runs the customer relationships and sales motions that drive growth. The problem is they don't talk to each other by default, which means your reps are often working from stale data while the good stuff sits in dashboards only analysts open. Connecting them through tray.ai cuts out the manual work — no more exporting reports, copying metrics, or updating records by hand. Your teams spend time on actual work instead of data wrangling.
Automate & integrate Looker & Salesforce
Use case
Sync Customer Health Scores from Looker into Salesforce Account Records
Customer success and sales teams need current health scores to prioritize outreach, but those scores are typically computed in Looker and never make it back into Salesforce automatically. With tray.ai, you can schedule Looker Look or Dashboard queries to run on a cadence and write the resulting health scores directly to Salesforce Account fields. Reps and CSMs always see current health data without leaving Salesforce.
Use case
Push Looker Product Usage Signals into Salesforce Opportunities
Product usage data computed in Looker — feature adoption rates, login frequency, usage depth — is a strong predictor of deal health and expansion potential, but it rarely surfaces where sales reps actually work. Connect Looker with Salesforce via tray.ai to automatically populate Opportunity fields with the latest usage signals, so reps can prioritize deals and have more informed conversations.
Use case
Automate Lead Scoring Updates from Looker to Salesforce Leads
Marketing and revenue ops teams often build sophisticated lead scoring models in Looker that pull in behavioral, firmographic, and historical data — but keeping Salesforce Lead scores current requires constant manual effort. With tray.ai, you can run Looker scoring queries on a schedule and write updated scores back to Salesforce Lead fields automatically, so your SDRs always prioritize the hottest leads.
Use case
Alert Salesforce Users When Looker Metrics Cross Critical Thresholds
Revenue and ops leaders need to know the moment a KPI shifts — pipeline drops, win rates fall, churn indicators spike — but Looker alerts don't natively create Salesforce Tasks or Chatter posts. By connecting Looker with Salesforce through tray.ai, you can trigger Salesforce notifications, Tasks, or Chatter messages automatically when Looker detects a metric crossing a predefined threshold, keeping the right people informed inside their CRM.
Use case
Enrich Salesforce Reports with Looker-Computed Segment and Tier Data
Segmentation and tiering logic built in Looker — customer lifetime value bands, ICP fit scores, market segment classifications — needs to live on Salesforce records to be useful in CRM views, reports, and workflows. Use tray.ai to automatically write Looker-derived segment labels and tier classifications to Salesforce Account or Contact custom fields on a recurring schedule, so segmentation stays current without anyone asking the analytics team to run it again.
Use case
Sync Salesforce Opportunity Data into Looker for Pipeline Analytics
Looker's analytics are only as good as the data feeding them, and Salesforce opportunity data sits at the center of any revenue analytics model. Use tray.ai to push Salesforce opportunity updates — stage changes, close date shifts, ARR changes — into your data warehouse in near real time so Looker dashboards reflect the current pipeline state without waiting for a nightly batch load.
Use case
Generate Salesforce Contacts and Campaigns from Looker Audience Exports
Marketing ops teams frequently build target audience lists in Looker using data models that span product, CRM, and behavioral sources. Rather than exporting those lists to CSV and importing them into Salesforce by hand, tray.ai can automate the whole process — triggering Looker queries on demand or on a schedule, then creating or updating Salesforce Contacts and Campaign Members automatically.
Get started with Looker & Salesforce integration today
Looker & Salesforce Challenges
What challenges are there when working with Looker & Salesforce and how will using Tray.ai help?
Challenge
Keeping Looker-Computed Metrics Fresh Inside Salesforce
Looker metrics are only as useful as they are current, but without automation, there's no native way to push Looker query results into Salesforce fields on a reliable schedule. Teams fall back on manual exports that go stale fast, and reps end up making decisions on outdated data.
How Tray.ai Can Help:
tray.ai's scheduler and Looker connector let you run any Looker Look or query on a configurable cadence and write the results immediately to Salesforce via the Salesforce connector's upsert capabilities. Your CRM fields stay current with the latest analytics output without anyone doing it by hand.
Challenge
Handling Large Result Sets from Looker Without Hitting Salesforce API Limits
Looker queries that return thousands of rows — full account or lead score refreshes, for example — can easily break a naive integration that makes one Salesforce API call per row. Rate limit errors pile up, syncs come through incomplete, and the failures are often silent until something downstream goes wrong.
How Tray.ai Can Help:
tray.ai handles this with native pagination support for Looker result sets and bulk API support for Salesforce, so large datasets process in configurable batches. Built-in retry logic and error handling catch failed records, log them, and retry without manual intervention.
Challenge
Matching Looker Records to the Correct Salesforce Objects Reliably
Looker data models often use internal database identifiers or email addresses as primary keys, while Salesforce uses its own record IDs and can have inconsistent external ID mappings. Mismatches produce duplicate records, missed updates, and data integrity problems that are painful to audit and fix.
How Tray.ai Can Help:
tray.ai's workflow logic lets you build flexible matching strategies — looking up Salesforce records by email, domain, external ID, or any custom field before deciding whether to create or update. Conditional branching ensures unmatched records get flagged and queued for review rather than silently dropped or duplicated.
Challenge
Triggering Real-Time Salesforce Actions from Looker Threshold Events
Looker's native alerting sends emails or Slack messages, but it can't create Salesforce Tasks, update record fields, or post Chatter messages when a metric crosses a threshold. Critical data signals never reach the workflows and people inside Salesforce who need to act on them.
How Tray.ai Can Help:
tray.ai bridges this by receiving Looker scheduled delivery webhooks or polling Looker queries on a tight schedule, evaluating threshold conditions with configurable logic, and then executing any Salesforce action — creating Tasks, updating fields, posting Chatter messages, or triggering flows — with full control over the data payload and target record.
Challenge
Maintaining Audit Trails and Data Lineage for Compliance
When Looker metrics and Salesforce records stay in sync through automated pipelines, revenue operations and compliance teams need a clear audit trail showing what data was written, when, by which workflow, and what the source query returned. This matters especially in regulated industries or companies with data governance requirements.
How Tray.ai Can Help:
tray.ai logs every workflow run in detail — the specific Looker query results processed, which Salesforce records were updated, timestamps, and any errors. You can export those logs or forward them to your data warehouse or logging platform, giving compliance and ops teams the lineage documentation they need.
Start using our pre-built Looker & Salesforce templates today
Start from scratch or use one of our pre-built Looker & Salesforce templates to quickly solve your most common use cases.
Looker & Salesforce Templates
Find pre-built Looker & Salesforce solutions for common use cases
Template
Scheduled Looker Health Score Sync to Salesforce Accounts
Runs a Looker Look query on a configurable schedule (daily, hourly, or weekly), maps the resulting customer health scores to Salesforce Account IDs, and updates the corresponding Account fields via the Salesforce API — with error logging for any records that fail to update.
Steps:
- Trigger workflow on a time-based schedule (e.g., every 24 hours)
- Run a specified Looker Look or query and retrieve results as structured data
- Loop through each result row, match to Salesforce Account by external ID or CRM ID field
- Update the Salesforce Account health score custom field via PATCH/upsert
- Log any failed updates and send an error summary notification
Connectors Used: Looker, Salesforce
Template
Looker Metric Alert to Salesforce Chatter Post
Monitors a Looker dashboard tile or scheduled query result for a threshold condition and automatically posts a formatted Chatter message on a specified Salesforce record or group when the condition is met, keeping revenue teams informed without leaving Salesforce.
Steps:
- Receive a Looker scheduled delivery webhook or poll a Looker Look on a schedule
- Evaluate the metric value against a configured threshold condition
- If threshold is breached, compose a formatted alert message with metric context
- Post the alert as a Salesforce Chatter message to the relevant record or group
Connectors Used: Looker, Salesforce
Template
Salesforce Opportunity Stage Change to Looker Data Warehouse Sync
Listens for Salesforce Opportunity stage change events via Salesforce Platform Events or polling, then immediately writes the updated opportunity record to your data warehouse so Looker reflects the change in near real time without waiting for a batch ETL window.
Steps:
- Trigger on Salesforce Opportunity update event (Platform Event or polling)
- Filter for relevant field changes such as Stage, Amount, or Close Date
- Transform the Salesforce record into the target data warehouse schema
- Write the transformed record to the data warehouse feeding Looker
- Optionally trigger a Looker PDT rebuild or cache invalidation
Connectors Used: Salesforce, Looker
Template
Looker Lead Score Refresh to Salesforce Lead Fields
Executes a Looker lead scoring query on a schedule, retrieves updated scores for all active leads, and performs a bulk upsert into Salesforce Lead records — keeping lead prioritization current for SDR teams without any manual data handling.
Steps:
- Trigger on a defined schedule (e.g., every 6 hours)
- Execute the Looker lead scoring Look and paginate through all result rows
- Batch lead score updates into Salesforce bulk upsert API calls
- Handle and log any upsert errors or unmatched Lead records
- Send a completion summary with record counts to the ops team via email or Slack
Connectors Used: Looker, Salesforce
Template
Looker Audience Export to Salesforce Campaign Member Creation
Triggers a Looker audience query on demand or on a schedule, then creates or updates Salesforce Contact and Campaign Member records based on the query results, automating the full pipeline from audience definition in Looker to campaign activation in Salesforce.
Steps:
- Trigger manually via tray.ai UI or on a scheduled cadence
- Run the target Looker Look to retrieve the audience list with Contact identifiers
- Check each audience member against existing Salesforce Contacts and upsert as needed
- Add matched or created Contacts to the specified Salesforce Campaign as Campaign Members
- Log results and notify the marketing ops team of completion
Connectors Used: Looker, Salesforce
Template
Bi-Directional Account Data Sync Between Salesforce and Looker Data Pipeline
Maintains a continuous sync of Salesforce Account attributes into the data warehouse powering Looker while simultaneously writing Looker-computed metrics back to Salesforce Account fields, creating a closed-loop data pipeline between your CRM and analytics platform.
Steps:
- Poll Salesforce for Account records modified since the last sync timestamp
- Write new or updated Account attributes to the data warehouse feeding Looker
- Run Looker queries to retrieve the latest computed metrics for those same Accounts
- Write Looker metric outputs back to the corresponding Salesforce Account custom fields
- Update the sync watermark and log the run summary for audit purposes
Connectors Used: Salesforce, Looker