This documentation page assumes that you already have a SeekTable account. Create your free account by signing up.

Zapier Integration

Zapier.com is a cloud-based service for codeless workflows automation by end users. Even with Zapier free plan for individuals you can configure some SeekTable automations:

More advanced use-cases are possible with multi-steps Zaps (available in paid plans):

SeekTable actions in Zaps

  1. Choose SeekTable app for the step in your Zap:
    SeekTable app in Zapier
  2. Get your API key by going to Manage AccountGet API Key button in SeekTable UI.
  3. Use Find a Report (exports), Upload CSV File and Share Report by Email in Zaps:
    Schedule report with Zapier
    Refresh CSV cube with Zapier

How to sync CSV cube with Google Sheet

You can create CSV cube by your Google Sheet data, and refresh it automatically each time when Google Sheet file is changed with the following 2-step zap (can be used on free plan):

  1. Move your Google Sheet file to separate folder in your Google Drive
  2. Choose trigger action: Updated File in Google Drive
  3. In "Customize Updated File" section choose a folder with your Google Sheet file
  4. As a 2-nd step choose Upload CSV File in SeekTable action
  5. In "Customize File" section choose a cube you want to refresh, for "CSV File Name" choose special option "File Csv":
    Sync Google Sheet with Zapier

How to refresh CSV cube on schedule

Another typical scenario is when you have an URL with CSV data and want to refresh your CSV cube from this URL on schedule (say, day). This also can be achieved with 2-step zap (can be used on free plan):

  1. Choose a trigger action as a 1-st step; for example, Schedule by Zapier.
  2. As a 2-nd step choose Upload CSV File in SeekTable action
  3. In "Customize File" section choose a cube you want to refresh, and specify an URL in "CSV File Name" field.
    Important notes:
    • If your URL is a Google Sheet share link, it should be like this one:
      https://docs.google.com/spreadsheets/d/UNIQUE_DOC_ID_HERE/export?format=csv
    • Max file size is 50Mb

How to send a report as an email attachment

  1. Choose some trigger action as a 1-st step; for example, Schedule by Zapier.
  2. For 2-nd step use SeekTable connector's Find a Report action. Choose a report you want to attach.
  3. Choose an action that can compose an email with attachment; for example Email by Zapier or SMTP by Zapier.
  4. At the form where you can specify email fields:
    • for Body you can choose (with top-right icon) only non-binary content; for example Find a Report → Report HTML (content with inline styles). In this way you can place your report directly into email body - in the same way as it comes in Share report by email action.
    • for Attachment choose export format you want to send a attachment; for example, Find a Report → Export to PDF file.