> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superjoin.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Scheduled Data Imports

> Scheduled Imports in Superjoin automates the process of keeping your data up-to-date by creating new static sheets on a regular basis—hourly, daily, weekly, or monthly. This feature helps ensure that your data remains current without manual intervention, allowing you to focus on analysis rather than data management.

<Check> Only available on Google Sheets </Check>

## Follow the quickstart guide to get started with Superjoin 🚀

<CardGroup cols={2}>
  <Card title="Quickstart" icon="flag-checkered" iconType="duotone" href="/quickstart">
    Install Superjoin in under a minute and start pulling your data instantly.
  </Card>

  <Card title="Common Issues" icon="life-ring" iconType="duotone" href="/issues-launching-superjoin">
    We've listed down common issues that you might face & how to fix it.
  </Card>
</CardGroup>

## Steps to create a scheduled Imports ✨

<Warning>Ensure Superjoin is installed and working before following the rest of the guide.</Warning>

### **Scheduled refreshes can be created in 2 ways:**

<AccordionGroup>
  <Accordion title="While creating a custom SQL query" defaultOpen="true">
    <Steps titleSize="h2">
      <Step title="Import the data">
        Import the data after configuring the query.
        Click on the `Import` button to import the data.

        <Tip>
          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](/features/queries/create-queries).
        </Tip>

        <Frame>
          <img src="https://mintcdn.com/superjoin/3kfktSzO4qKVejPu/images/scheduled-refresh/2-import-data.png?fit=max&auto=format&n=3kfktSzO4qKVejPu&q=85&s=823af6f26cb4f4d81918811bbe91fb0b" width="3024" height="1714" data-path="images/scheduled-refresh/2-import-data.png" />
        </Frame>
      </Step>

      <Step title="Set up the scheduled Imports">
        After a successful import, a drawer will open up with the option to create a scheduled refresh.

        <Frame>
          <img src="https://mintcdn.com/superjoin/3kfktSzO4qKVejPu/images/scheduled-refresh/3-while-creating-query.png?fit=max&auto=format&n=3kfktSzO4qKVejPu&q=85&s=abf82d09b2b7c6a2913d6af70dded276" width="3024" height="1714" data-path="images/scheduled-refresh/3-while-creating-query.png" />
        </Frame>

        * 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.

        <Tip>
          You can also create a `Flashback`, learn more about it [here](/features/flashbacks).
        </Tip>
      </Step>

      <Step title="Schedule the Import">
        * Click on `Schedule` to schedule the Imports using the desired config.
        * New schedule will be displayed in the `Automatic Refreshes` card.

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/flashbacks/3-flashback-sched.png?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=f8e44854d08d1c9cdff84e7df4452e1f" width="3024" height="1716" data-path="images/flashbacks/3-flashback-sched.png" />
        </Frame>
      </Step>
    </Steps>
  </Accordion>

  <Accordion title="After creating a custom SQL query">
    <Steps titleSize="h2">
      <Step title="Open queries page">
        Click on the `Queries` tab. This will open the queries page in the sidebar.

        <Frame>
          <img src="https://mintcdn.com/superjoin/95T8cmea616drJuC/images/queries/0-home-page.png?fit=max&auto=format&n=95T8cmea616drJuC&q=85&s=32712aa727d3dc4e6c4aba33e9f119b1" width="3024" height="1716" data-path="images/queries/0-home-page.png" />
        </Frame>
      </Step>

      <Step title="Select a query">
        Click on the desired query which you wish to create a flashback for.
        <Tip>You can use the `Queries` tab in the documentation to set-up queries.</Tip>

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/flashbacks/0-queries-page.png?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=ed1642cb3a6217c04bdd82ef692f3e2c" width="3024" height="1716" data-path="images/flashbacks/0-queries-page.png" />
        </Frame>
      </Step>

      <Step title="Create a new scheduled Imports">
        Click on `Create Schedule` button in the `Automatic Refreshes` card.

        <Frame>
          <img src="https://mintcdn.com/superjoin/3kfktSzO4qKVejPu/images/scheduled-refresh/0-select-query.png?fit=max&auto=format&n=3kfktSzO4qKVejPu&q=85&s=7d0dcf772590fa69e36d6695e7ffa3e0" width="3024" height="1714" data-path="images/scheduled-refresh/0-select-query.png" />
        </Frame>
      </Step>

      <Step title="Configure the scheduled Imports">
        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/flashbacks/2-flashback-config.png?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=2b50a7f5fa3262d53f5a2cb55a38a0eb" width="3024" height="1716" data-path="images/flashbacks/2-flashback-config.png" />
        </Frame>

        * 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.

        <Tip>
          You can also create a `Flashback`, learn more about it [here](/features/flashbacks).
        </Tip>
      </Step>

      <Step title="Schedule the Import">
        * Click on `Schedule` to schedule the refresh using the desired config.
        * New schedule will be displayed in the `Automatic Refreshes` card.

        <Frame>
          <img src="https://mintcdn.com/superjoin/YLExbgl86h2tZ50q/images/flashbacks/3-flashback-sched.png?fit=max&auto=format&n=YLExbgl86h2tZ50q&q=85&s=f8e44854d08d1c9cdff84e7df4452e1f" width="3024" height="1716" data-path="images/flashbacks/3-flashback-sched.png" />
        </Frame>
      </Step>
    </Steps>
  </Accordion>
</AccordionGroup>
