Freshsales

Section header image mobile
Transform how you manage your Sales Pipeline by Coefficient's Freshsales connector on Google Sheets. With this integration, you can view real-time data, including deals and sales opportunities, contacts, sales activities, and tasks, in your spreadsheet without manually extracting data from Freshsales and with just a few prompts. 🤖

Connecting to Freshsales

Import from Freshsales

Schedule your Import, Snapshots, and Add Automations

FAQs for Freshsales Integration

Connecting to Freshsales 

When you begin a Freshsales import for the first time, you will need to go through a few steps to connect to Freshsales as a data source for Coefficient.

1. Open the Coefficient Sidebar and click the Menu.

Screenshot 2025-09-26 at 6.52.08 AM.png

2. Select “Connected Sources”.

Connected Sources2.png

3. Select “Add Connection” at the bottom and then select “Connect” to Freshsales.

4. Generate an API Key for your account in Freshsales. 

ℹ️ NOTE: If an API Key is not yet created for your account, it needs to be created from the Freshsales platform. 
Click your profile icon > Profile Settings > API section > Generate/copy your API Key.

Please see the Freshsales API documentation for details. 

5. Enter the API Key generated from Freshsales and click Connect.

6. When successful, you can proceed with creating an import by clicking the "Import data..." button at the bottom.

Import from Freshsales

1. Open the Coefficient Sidebar and click on the “Import from…” button.

2. Select your “Freshsales” connection from the list.

3. Enter a clear and specific prompt describing your request for the data you need from Freshsales.

4. Fields relating to your request will appear in the sidebar for your to select/unselect to include in your import. Click on "Add fields" to show all available fields. Click "Import" to proceed.

5. Please allow a moment for the agent to generate your import. (The results will appear shortly.) Congratulations on creating your first Freshsales import through the agent chat! 🎉

Schedule your Import, Snapshots, and Add Automations

Once you have pulled your data into your spreadsheet using Coefficient, you can set up the following:

1. Schedule your Import

Screenshot 2025-09-16 at 8.02.41 AM.png

2. Turn on Snapshots

Screenshot 2025-09-16 at 7.20.51 AM.png
Screenshot 2025-09-16 at 7.20.58 AM.png

3. Set Up Automations

Screenshot 2025-09-16 at 7.22.00 AM.png

FAQs for Freshsales Integration

How can I update or add filters to refine the data in my Freshsales import?

To edit your import, open it from the sidebar and click “Edit this import” under the summary section (see screenshot).

From there, enter a new prompt in the agent chat describing the updates you’d like to make (such as adding filters or adjusting sorting).

Can I schedule my import for auto-refresh after it has been created by the agent?

Yes, once your import has been created by the agent, you can schedule it to auto-refresh from the “Refresh Schedule” section in the sidebar.

How can I provide feedback about my experience with the agent chat?

After your import is created, a prompt will appear in the sidebar allowing you to share your experience with the agent by selecting like or dislike. 

Your feedback helps us continue to improve the experience. 🙏🏼

 

Was this article helpful? 0 out of 0 found this helpful