For Enterprise customers: Connect your Salesforce CRM to Coda with this integration
With the Salesforce Pack, you can bring your Salesforce data into Coda for a complete single source of truth. And with two-way sync, you can even make edits to the data via Coda. You'll need to have Salesforce access to enable the Pack. But like all Packs, it’s enabled on the doc level, so your teammates without Salesforce access can view the data once you’ve set it up for them. This article will explain how to connect to and set up the Salesforce Pack in Coda.
📣 Note: the Salesforce Pack is currently only included on Coda's Enterprise tier. It can also be purchased a la carte.
Within this article, you’ll find...
- Add the Salesforce Pack to your doc
- Connect to the Salesforce Pack
- Get started with the Salesforce Pack
- FAQs
Add the Salesforce Pack to your doc
- Type /Salesforce on any blank line in your doc. Select the Salesforce option from the menu (under the More Packs section). Then click Add to doc*.
- In the upper-right corner of your doc, click on Insert. Enter Salesforce in the search bar, select the Salesforce Pack, and click Add to doc*.
Connect to the Salesforce Pack
- If you’re a Salesforce admin and you have not completed this pre-authorization for your organization, check out the Admin authorization section below to learn more.
- If your Salesforce admin has already completed this process and you’re ready to connect your individual account to the Salesforce Pack, jump to the Connect your Salesforce account section.
Admin authorization
📣 To learn more about the changes made by Salesforce, which impact all connected apps, head to this page.
- Log in to Salesforce via your Salesforce administrator account
- Navigate to the Set up section
- Select Connected Apps OAuth Usage
- Find ‘Coda’ in the list of apps that have connected to your organization
- Note: If no one in your Coda organization has previously connected to the Salesforce Pack, you will not see the Coda app listed here. You must therefore return to Coda, install the Salesforce Pack in a doc, and connect to the Pack using your Salesforce admin account. Because you are a Salesforce admin, this connection will be successful. You can then return to this step in the process in Salesforce, where you should now see the Coda app listed.
- Click the Install button next to the Coda app, then click Install again on the next screen to confirm.
Connect your Salesforce account
- Within your Coda doc, navigate to the already-installed Salesforce Pack. You can do this by clicking on Insert in the upper-right corner of the doc, selecting the Packs tab, and selecting Salesforce (within the Installed Packs section).
- From here, click on the Settings tab.
- Decide whether you want to connect an account for taking private actions or add a shared synced account (learn more about these options below), and press the Connect an account button.
- Press the Sign in with Salesforce button to initiate the authorization, then follow the prompts to complete the connection.
- An account for taking private actions is one that only you - the person who set it up - can use to take actions in the Coda doc. This is recommended for things like buttons.
- A synced account is one that, by default, can be used to sync data into the Coda doc. Anyone who has access to the doc will be able to view data that’s synced in (e.g. if you add a sync table of Google calendar events, everyone on the doc will be able to view the data on that table). Use this type of connection for sync tables.
Get started with the Salesforce Pack
Tables
- Objects
- Fields
- Report (two-way sync available)
- Records (two-way sync available)
Buttons
- Create record
- Upsert record
- Update record
- Delete record
Formulas
- LookupRecords()
- LookupOpportunities()
- LookupAccounts()
- LookupCampaigns()
- LookupContacts()
- LookupLeads()
- LookupCases()
- LookupTasks()
📣 Looking for examples and inspiration for using the Salesforce Pack building blocks in your doc? Check out these resources:
- Getting started with the Salesforce Pack | Coda Guides
- Account Hub | Coda templates
- Account Viewer | Coda templates
FAQs
Why am I seeing an “OAuth error” when attempting to connect to the Salesforce Pack?
OAuth errors indicate that there is some restriction from Salesforce that’s preventing you from connecting Salesforce and Coda.
How do I pre-approve the Coda app in Salesforce, to ensure that members of my org can connect to the Salesforce Pack?
In order for members of your org to connect to the Salesforce Pack in Coda, a Salesforce administrator must complete a one-time pre-approval process within Salesforce. If you’re a Salesforce admin, you can follow the steps in the “Admin authortization” section of this article to learn more.
Approve uninstalled connected apps permission in Salesforce will need to follow the steps outlined in this article to install and connect to the Salesforce Pack. Once that’s done, the Salesforce admin can complete the authorization process in Salesforce.How do I take actions in Salesforce from Coda?
How can I learn more about the Salesforce Pack?