Google Sheets: Installing and Using

The PipelineDeals Data Importer allows you to import your saved list views from PipelineDeals into Google Sheets. Use the simple, intuitive interface to pull live data into Google and build powerful reports. Each worksheet supports its own filter. Refresh all of your worksheets with a single click to keep the data live and your reports updated.

Add new sheets to create pivot tables, formulas, graphs, and charts to slice, dice, and visualize your data.

Installing

You need to have export permissions in your PipelineDeals account to use the Google Sheets integration. If you don't have export permissions, contact an administrator on your PipelineDeals account.

You can install the PipelineDeals Google Sheets add-on from the Chrome Web Store.  

Alternatively, if you have a specific Google Sheet open (as in, a live spreadsheet) you can go to Add-ons > Get add-ons ... and search for 'PipelineDeals', then click Free. Click Accept to allow PipelineDeals to send data to your Google Sheets account. You now have the integration installed and you are ready to start importing your data.

Import your data

You can access your saved filters in PipelineDeals by going to Add-ons > PipelineDeals Data Importer > Manage Filters.  You'll be prompted to log into PipelineDeals.

PipelineDeals data importer

You can then choose which filter you wish to import into the current sheet. You can import one filter per sheet.

Manage filters

If you've recently added a filter to PipelineDeals that you don't see in the list, click Refresh list of filters. To refresh the data on all the sheets you currently have open, click Refresh Data.

NOTE: Importing a filter or refreshing the data will clear out all the data on the current sheet. Any formulas, charts, or graphs created using the data should be placed on a separate sheet.

Share a sheet

To share a spreadsheet, use the Share button in Google Sheets. Any changes you make to the sheet will be visible to the person you shared it with.

Share and comment

FAQs

Can I update data in my PipelineDeals account using Google Sheets?
No, changes you make to data in Google Sheets will not update in PipelineDeals


Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.