Salesforce

Salesforce is a leading cloud-based CRM platform that stores all your customer data—accounts, contacts, opportunities, cases, and more. With Coupler.io, you can automatically export your Salesforce data to Google Sheets, Excel, BigQuery, Looker Studio, or AI destinations like Claude and ChatGPT on a schedule that works for your business.

Why connect Salesforce to Coupler.io?

• Multiple export options — Pull data using Salesforce reports, standard/custom objects, or write custom SOQL queries for precise control

• Save time on manual exports — Schedule automatic refreshes daily, weekly, or monthly instead of downloading reports by hand

• Combine Salesforce data with other sources — Use transformations like Join and Append to blend Salesforce data with marketing, finance, or other systems

• Feed AI tools directly — Send Salesforce records to Claude or ChatGPT for instant analysis, summarization, or content generation

Prerequisites

• An active Salesforce account (Standard, Professional, Enterprise, or Unlimited edition)

• Administrator or equivalent permissions to authorize Coupler.io

• For custom SOQL queries: basic familiarity with SOQL syntax (or use the Objects data type with filters)

Quick start

The easiest way to start is to use the Objects data type to pull standard fields from a single object (Accounts, Contacts, Opportunities, etc.). Once you're comfortable, explore Reports or Custom SOQL for more advanced use cases.

How to connect

1

Sign in to Coupler.io and create a new data flow. Search for and select Salesforce as your source.

2

Authorize Coupler.io by clicking the sign-in button. You'll be redirected to Salesforce's login page. Enter your Salesforce credentials and approve the connection request. Once authorized, you'll return to Coupler.io.

3

Choose your data type: Select Reports (to pull from existing Salesforce reports), Objects (to export accounts, contacts, opportunities, etc.), or Custom SOQL (to write your own queries).

4

Configure your selection:

• If Reports: Pick a tabular report from your Salesforce org. Optionally override the report's date range.

• If Objects: Choose an object (e.g., Account, Contact, Opportunity) and optionally filter by date or add SOQL filters.

• If Custom SOQL: Write your query (e.g., SELECT Id, Name, Revenue FROM Account WHERE Industry = 'Technology').

5

Select your destination — Google Sheets, Excel, BigQuery, Looker Studio, or an AI destination like Claude or ChatGPT. Map Salesforce columns to destination columns if needed.

6

Run the data flow by clicking Run to complete a successful manual test. Once it succeeds, your data flow is ready—scheduling can be set up afterward.

Supported Salesforce editions

Coupler.io works with Salesforce Standard, Professional, Enterprise, and Unlimited editions.

Available data types

Salesforce data is exported through three methods, each offering different levels of flexibility and control.

Data type	What it exports	Use case
Reports	Pre-built Salesforce reports in tabular format	Dashboard summaries, executive reports, sales pipeline
Objects	Raw records from standard or custom objects (Accounts, Contacts, Opportunities, Cases, Leads, etc.)	Detailed transaction data, customer records, activity logs
Custom SOQL	Results from custom SOQL queries with multi-object joins and complex filters	Advanced analytics, cross-object aggregations, custom data combinations

Common Salesforce objects

When using the Objects data type, you can export from any of these standard objects (plus any custom objects in your org):

Core CRM objects

• Account — Company records with name, industry, revenue, website, billing address

• Contact — Individual contact records linked to accounts

• Opportunity — Sales deals with amount, stage, close date, probability

• Lead — Potential customers not yet converted

• Campaign — Marketing campaigns and campaign members

Service objects

• Case — Support tickets with status, priority, subject, description

• Task — Activities assigned to users

• Event — Calendar events and meetings

Custom objects

Any custom objects defined in your Salesforce org are also available for export.

Standard fields by object

Account fields

• Id, Name, Type, Industry, Revenue, Website, Phone, BillingStreet, BillingCity, BillingState, BillingPostalCode, BillingCountry, CreatedDate, LastModifiedDate

Contact fields

• Id, FirstName, LastName, Email, Phone, MobilePhone, Title, Department, AccountId, CreatedDate, LastModifiedDate

Opportunity fields

• Id, Name, AccountId, Amount, StageName, CloseDate, Probability, CreatedDate, LastModifiedDate

Case fields

• Id, CaseNumber, Subject, Status, Priority, Description, AccountId, ContactId, CreatedDate, LastModifiedDate

Lead fields

• Id, FirstName, LastName, Company, Email, Phone, LeadSource, Status, CreatedDate, LastModifiedDate

Custom fields

If your Salesforce org has custom fields, you can include them in your export by specifying their API names when using the Objects data type. Custom field names typically end with __c.

Date filtering

When exporting objects, you can filter records by when they were created or last modified:

• Changed after date — Include only records modified after this date

• Changed before date — Include only records modified before this date

• Both support relative dates using macros (e.g., {{30daysago}})

For reports, you can override the report's built-in date range by specifying custom start and end dates.

SOQL filters

When using Objects, you can add WHERE conditions using SOQL syntax:

• Industry = 'Technology' — Filter by field value

• CreatedDate >= LAST_N_DAYS:30 — Filter by relative date

• Amount > 10000 — Numeric comparisons

• Status IN ('Closed Won', 'Closed Lost') — Match multiple values

Use cases by role

Sales teams

Export your Opportunity or Account data to track pipeline, close rates, and deal progress. Pull reports on quota attainment or forecast accuracy. Use Custom SOQL to join Opportunities with Accounts to see deal size by industry. Send opportunity summaries to Claude or ChatGPT for sales coaching feedback.

Finance and operations

Export Account revenue, billing information, and annual contract value (if using custom fields). Pull from reports to track bookings, MRR, or churn. Use Append to combine multiple report periods into one dataset for trend analysis. Send financial summaries to BigQuery for consolidated reporting.

Customer success

Export Case data to track support volume and resolution times. Pull Contact records linked to Accounts to monitor customer health. Use SOQL to find open cases by priority or age. Join Cases with Accounts to identify at-risk customers.

Marketing

Export Lead and Campaign Member data to track campaign performance. Pull custom fields if you're tracking lead scoring or attribution. Use SOQL to segment leads by source or status. Append data from multiple campaigns for cohort analysis.

Platform-specific notes

• Tabular reports only — Matrix and summary reports are not supported; convert them to tabular format in Salesforce

• Custom fields require API names — Use the exact API name (e.g., Customer_Tier__c) when specifying custom fields

• SOQL syntax matters — Typos in SOQL queries will cause import failures; refer to Salesforce SOQL documentation for syntax

• Rate limits — Salesforce enforces API call limits based on your edition; large exports may consume multiple API calls

• Sandbox and production — Data flows work with both sandbox and production orgs; ensure you're authorizing the correct environment

• Inactive users and archived data — By default, exports include only active records; use SOQL filters to include archived data if needed

Salesforce common issues

Connection issues

"Unexpected token" error when exporting reports

Salesforce reports that contain special characters (like underscores) in column headers can cause parsing errors. This usually happens with matrix or summary reports that don't export cleanly as tabular data.

Fix: Ensure your report is in tabular format (not matrix or summary). If it is, try exporting the report directly from Salesforce first to confirm the format is clean. If the report still fails, use the Objects or Custom SOQL data type instead to pull the underlying data directly.

Connection fails with custom Salesforce domain

If your Salesforce org uses a custom domain (not the standard login.salesforce.com), the OAuth flow may not recognize your login URL.

Fix: When signing in to Coupler.io, you may need to manually enter your custom domain URL. If this persists, contact Coupler.io support with your domain name and we can help route the connection correctly.

Cannot connect to Salesforce sandbox

Sandbox environments require a slightly different login URL than production orgs.

Fix: When authorizing, use your sandbox login credentials and ensure the login URL includes sandbox (e.g., https://yourorg--sandbox.sandbox.my.salesforce.com). Coupler.io supports both production and sandbox orgs.

"REST API is not enabled for this organization" error

Your Salesforce org may have API access disabled, which Coupler.io requires to pull data.

Fix: Contact your Salesforce administrator and request that the REST API be enabled for your org. This is typically found under Setup > System Overview > API is enabled.

Missing data

Custom fields are not appearing in the export

When exporting Objects, custom fields won't be included automatically. You must explicitly specify them in the Columns field.

Fix: In the Columns field, list the API names of your custom fields (e.g., Customer_Tier__c, ARR__c). Custom field API names typically end with __c. If you don't know the exact API names, check Salesforce Setup > Custom Fields & Relationships for your object.

Report shows data in Salesforce but nothing exports to Coupler.io

This usually happens if the report is in matrix or summary format, which Coupler.io doesn't support, or if the report has no data for the selected date range.

Fix: Verify the report is in tabular format. In Salesforce, edit the report and check the format setting. Also check the report's date range—if you're using a custom date filter in Coupler.io, ensure it overlaps with data in your Salesforce org.

SOQL query returns no results but I know data exists

Syntax errors in your SOQL query or incorrect field/object names will cause the query to return empty results.

Fix: Check your SOQL syntax against Salesforce documentation. Verify object and field names are spelled correctly (case-sensitive). Test the query in Salesforce's Developer Console first.

Permission errors

"Insufficient privileges" error during connection

Your Salesforce user account doesn't have permission to authorize third-party applications like Coupler.io.

Fix: Ask a Salesforce administrator to authorize the Coupler.io OAuth app, or request that your user profile be granted "Manage Connected Apps" permission.

Can see some objects but not others

Your Salesforce user profile has field-level security or object-level security restrictions that limit what you can export.

Fix: Contact your Salesforce administrator to grant read access to the objects or fields you need. They can adjust security settings under Setup > Security Controls > Field-Level Security or Object-Level Security.

Data discrepancies

Report data in Coupler.io doesn't match Salesforce

Reports often contain summaries, subtotals, or grouping logic that may not match the raw record count. Also, the date range override in Coupler.io changes what the report filters.

Fix: Compare the date range and filters in your Coupler.io data flow settings with the report definition in Salesforce. If you override the report's date range in Coupler.io, the exported data will reflect those new dates. For a true comparison, export the report directly from Salesforce with the same date range and filters.

Duplicate records appearing in exports

Duplicate records sometimes occur if a data flow is run multiple times in quick succession or if SOQL filters aren't specific enough.

Fix: Check your data flow's filter settings. If using Objects, add a more specific WHERE clause in SOQL (e.g., filter by status or date range). For scheduled data flows, ensure you're not appending to destination data without cleaning up old records first.

Report contains only 2000 rows

Salesforce's API returns the first 2000 rows of the report. If the report contains more than that, Coupler.io will show a warning however the import will be successful.

To get the full report is it recommended by Salesforce to narrow the results by filtering. Date filtering is possible in Coupler.io but other filers need to be applied on the Salesforce side. All filters are applied to the report when extracting it using Salesforce. The one exception is the limit rows filter which does not work via API.

Rate limits

Large exports are slow or timeout

Salesforce limits API calls per user per 24 hours. Large exports consume multiple API calls and may hit this limit.

Fix: Split large exports into smaller data flows (e.g., by date range or account segment). Schedule data flows during off-peak hours to avoid competing requests. For very large exports, contact Coupler.io support to discuss optimizations or reach out to Salesforce about raising your API call limits.

"API request limit exceeded" error

Your org has hit its daily API call quota due to multiple imports, reports, or other API integrations running simultaneously.

Fix: Stagger your data flow schedules so they don't all run at the same time. Remove or pause data flows you no longer need. Contact your Salesforce administrator to check your API usage in Setup > System Overview.

Salesforce FAQ

Can I export data from multiple Salesforce objects in one data flow?

Not directly in a single Objects export, but you have two options: (1) Create separate data flows for each object and use the Append transformation in Coupler.io to combine them in your destination, or (2) Use Custom SOQL with a JOIN query to combine data from related objects (e.g., SELECT Account.Name, Opportunity.Amount FROM Opportunity WHERE Account.Type = 'Customer').

What's the difference between Objects and Custom SOQL?

Objects lets you pick a standard or custom object and optionally add filters using a simple SOQL WHERE clause. Custom SOQL lets you write your entire query from scratch, including JOINs across objects, complex aggregations, and precise field selection. Use Objects for basic exports; use Custom SOQL when you need advanced control.

Can I export Salesforce data to BigQuery?

Yes. In your data flow, select BigQuery as the destination. Coupler.io will automatically create a table and schema based on your Salesforce export. You can then query that data in BigQuery for analysis.

How do I include custom fields in my export?

When using the Objects data type, specify custom field API names in the Columns field, separated by commas. Custom field names end with __c (e.g., ARR__c, Industry_Segment__c). Check your Salesforce object's field list to find exact API names.

Are sandbox environments supported?

Yes. When authorizing Coupler.io, use your sandbox login URL and credentials. Coupler.io works with both production and sandbox orgs.

Can I export a Salesforce report that's updated by formulas or roll-ups?

Yes, as long as the report is in tabular format. Matrix and summary reports that use special formatting or grouping are not supported. Convert your report to tabular format in Salesforce first.

What happens if I override a report's date range in Coupler.io?

The exported data will use the date range you specify in Coupler.io, not the report's built-in range. For example, if your report is set to "Current Quarter" but you specify "Last 90 days" in Coupler.io, the export will show the last 90 days.

How granular can I get with my Salesforce exports—can I filter by individual fields?

Yes. Use the SOQL WHERE clause in the Objects data type to filter by any field value. For example: Industry = 'Technology' AND AnnualRevenue > 1000000. For even more control, use Custom SOQL to write complex queries with multiple conditions, JOINs, and aggregations.

Can I send Salesforce data to Claude or ChatGPT?

Yes. In your data flow, select Claude, ChatGPT, Cursor, Gemini, Perplexity, or OpenClaw as your destination. Coupler.io will send your Salesforce records directly to the AI tool. This is useful for summarizing deal pipelines, generating customer success actions, or drafting sales coaching feedback.

Why is my export timing out or running slowly?

Large exports consume many Salesforce API calls and may hit rate limits. Try filtering by date range to reduce the volume of records exported, splitting the export into smaller date ranges, or staggering your data flow schedules so they don't run simultaneously. See the Performance Optimization section in Best Practices for more tips.

Can I append multiple Salesforce exports into one sheet or table?

Yes. Create multiple data flows (one for each export) and configure each to append data to the same destination sheet or table instead of replacing it. This is useful for tracking historical trends or combining data from different objects or reports.

What if my Salesforce report uses a custom date range filter I can't override?

If the report's date range is locked, consider using the Objects or Custom SOQL data type instead to pull the raw data with your own date filters. Alternatively, ask your Salesforce administrator to adjust the report's filter settings to allow overrides.