)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
The native Salesforce Data Connector can’t access custom objects because it was designed only for standard objects and lacks the flexibility to handle diverse schema variations.
Here’s how to import all your custom objects, fields, and relationships without any restrictions.
Import all Salesforce custom objects using Coefficient
Coefficient provides full support for ALL Salesforce custom objects, making it essential for organizations with customized Salesforce implementations. You can access any custom object visible to your Salesforce user, including all custom fields, formula fields, and complex relationships.
How to make it work
Step 1. Open Coefficient in Google Sheets and connect to Salesforce.
Install Coefficient from the Google Workspace Marketplace and authorize your Salesforce connection. The platform automatically detects all objects you have access to, including custom ones.
Step 2. Select “Import from Salesforce” and choose “From Objects & Fields”.
This method gives you access to the complete object schema. Your custom objects appear alongside standard objects in the selection list, clearly marked with their API names.
Step 3. Select your custom object and choose fields.
Browse through extensive field lists that include all custom fields, formula fields, and lookup relationships. You can select any combination of fields from your custom object and related objects.
Step 4. Apply filters using complex AND/OR logic.
Set up sophisticated filtering on custom fields using operators like equals, contains, greater than, and date ranges. Dynamic filters let you point to cell values for flexible querying.
Step 5. Use custom SOQL queries for advanced relationships.
Write custom queries to join multiple custom objects or access parent-child hierarchies. For example:
Access your complete Salesforce data model
Custom objects contain your most valuable business data, and you shouldn’t be limited by connector restrictions. Coefficient’s comprehensive custom object support ensures you can analyze all your Salesforce data in Google Sheets. Start importing your custom objects today.
