Only available on Google Sheets
Introduction
Formula filldown automatically populates any formulas that you have in the spreadsheet in the immediate right columns of the imported data every time you refresh the data. This saves you the time (and hassle) of manually going into your spreadsheet and copying your formula(s) down the row(s) manually.
How to use Formula filldown
1
Import Data with Superjoin
Use Superjoin to import data from your preferred source. Navigate to the 
Sources
tab in the Superjoin sidebar, and connect to your
desired data source (e.g., HubSpot, Salesforce, etc). Click on import data (in data preview) and wait for your data to be populated on
Google sheet.
2
Add your custom columns with formulas
Open the sheet where you’d like to import data. Ensure that any formulas you want to apply to imported data are in the columns immediately
next to the imported data.

3
Refresh your data
When you refresh the data, the formula you placed in the immediate next column will automatically populate down the rows of your imported
data during every refresh. No need to manually copy formulas anymore!
Note: Ensure the column with the formula is directly adjacent to the imported data, as the filldown only works for immediate
columns.

4
Schedule Data Refresh
To automatically refresh your data and keep your formulas updated, you can schedule a refresh in Superjoin. Navigate to the 

Schedule
option and set a daily, weekly, or monthly refresh. Make sure to keep the Formula Auto-filldown mode on.

5
Verify Formula Population
After the refresh, verify that your formulas have populated correctly in the new rows of the data, ensuring your spreadsheet stays up to
date.