Scheduled Data Imports

Only available on Google Sheets

Follow the quickstart guide to get started with Superjoin 🚀

Quickstart

Install Superjoin in under a minute and start pulling your data instantly.

Common Issues

We’ve listed down common issues that you might face & how to fix it.

Steps to create a scheduled Imports ✨

Ensure Superjoin is installed and working before following the rest of the guide.

Scheduled refreshes can be created in 2 ways:

Import the data

Import the data after configuring the query. Click on the Import button to import the data.

A scheduled Imports can be created in the last step of creating a custom SQL query. Follow the guide to create a custom SQL query here.

Set up the scheduled Imports

After a successful import, a drawer will open up with the option to create a scheduled refresh.

You can choose to create a scheduled Imports right away or click I'll do this later to skip it.
You can choose to creata a scheduled Imports on an hourly, daily, weekly or monthly basis.
If hourly, select the desired time interval (Available intervals are {6, 8, 12} hours).
If daily, select the desired time of the day.
If weekly, select the desired day of the week and time of the day.
If monthly, select the desired date of the month and time of the day.

Advanced option (Optional):

Refresh mode provides the option to append or replace the data.
Append: Appends the modified and new rows to the existing sheet.
Replace: Replaces the modified rows and adds new rows to the existing sheet.

You can also create a Flashback, learn more about it here.

Schedule the Import

Click on Schedule to schedule the Imports using the desired config.
New schedule will be displayed in the Automatic Refreshes card.

Open queries page

Click on the Queries tab. This will open the queries page in the sidebar.

Select a query

Click on the desired query which you wish to create a flashback for.

You can use the Queries tab in the documentation to set-up queries.

Create a new scheduled Imports

Click on Create Schedule button in the Automatic Refreshes card.

Configure the scheduled Imports

You can choose to creata a scheduled Imports on an hourly, daily, weekly or monthly basis.
If hourly, select the desired time interval (Available intervals are {6, 8, 12} hours).
If daily, select the desired time of the day.
If weekly, select the desired day of the week and time of the day.
If monthly, select the desired date of the month and time of the day.

Advanced option (Optional):

Refresh mode provides the option to append or replace the data.
Append: Appends the modified and new rows to the existing sheet.
Replace: Replaces the modified rows and adds new rows to the existing sheet.

You can also create a Flashback, learn more about it here.

Schedule the Import

Click on Schedule to schedule the refresh using the desired config.
New schedule will be displayed in the Automatic Refreshes card.

Getting Started

Features

Useful Tools

Follow the quickstart guide to get started with Superjoin 🚀

Quickstart

Common Issues

Steps to create a scheduled Imports ✨

Scheduled refreshes can be created in 2 ways:

Import the data

Set up the scheduled Imports

Schedule the Import

Open queries page

Select a query

Create a new scheduled Imports

Configure the scheduled Imports

Schedule the Import

Getting Started

Features

Useful Tools

​Follow the quickstart guide to get started with Superjoin 🚀

Quickstart

Common Issues

​Steps to create a scheduled Imports ✨

​Scheduled refreshes can be created in 2 ways:

Follow the quickstart guide to get started with Superjoin 🚀

Steps to create a scheduled Imports ✨

Scheduled refreshes can be created in 2 ways: