See also

Tags

product first_step
24 Jul 2024 01:23 AM

Export Data From SaaS Applications to Your Spreadsheet or Dashboard

close

You can download data from your business applications in just a few clicks.

Our product integrates with 500 B2B SaaS applications, including Shopify, Salesforce, HubSpot, Google Analytics, Quickbooks, Zendesk, Stripe and 500+ other systems, as well as various databases and APIs.

This allows you to automatically update your spreadsheets and dashboards with live data.

Depending on your need to modify the data before writing it to the spreadsheet, we provide two tools: Imports and Workflows.

Imports

  1. Start by selecting the application you want to use.
  2. Click on the "Import" button.
  3. If you have multiple accounts, select the appropriate one. Then, choose the table you want to import.
  4. If necessary, wait for the first portion of data to load.
  5. Open the spreadsheet where you want to send the data.
  6. Ensure the spreadsheet allows data editing. Alternatively, you can permit our application 1. to write to your Google Drive.
  7. Copy the spreadsheet URL and paste it into the designated field.
  8. Click on the "Import" button.
  9. Everything is now ready.
  10. You can automate this process by setting up a schedule.

Workflows

If you need to change data dimensions, use workflows.

  1. Create a new workflow.
  2. Add a block for loading data.
  3. Add a block for changing dimensions, such as keeping only the campaign name and 1. advertising costs.
  4. Ensure the data meets your requirements.
  5. Indicate the destination for writing the data.
  6. Launch the workflow.
  7. Your spreadsheet is ready.

To summarize:

  • For data with modifications, use Workflows.
  • For unmodified data, use Imports.