Auto-schedule imports from Google Sheets, Google Drive Files, Dropbox, or CSV and XLSX files on FTP/SFTP servers
How to automate fetching Google Sheets, Google Drive, Dropbox, or CSV / XLSX files and import to any app or API.
Quick Links:
- How to set up a scheduled fetcher for CSV or XLSX files from FTP / SFTP / FTPS
- How to set up a scheduled fetcher for Google Sheets
- How to set up a scheduled CSV or XLSX export for Airtable
- How to set up a scheduled fetcher for CSV files on Google Drive
- How to set up a scheduled fetcher for Dropbox
- How to set up a scheduled fetcher for Box
- How to set up a scheduled fetcher for OneDrive
- How to set up a scheduled fetcher for Amazon S3
- How to set up a scheduled fetcher for Shopify Orders
- How to set up a scheduled fetcher for Shopify Products & Variants
- Fetch on demand with a POST API request
How to set up a scheduled fetcher for Google Sheets
Step-by-step Instructions
- Sign in to your EasyCSV Account
- Create a spreadsheet import page by selecting an example CSV file or Google Sheet. You can also type out column headers of a spreadsheet you don't have at the moment. Usually using an example spreadsheet that is already made is the best way to go.
- Once viewing your new import page click the "Scheduled Fetcher" link in the top nav.
- Click the button "New Scheduled Fetcher"
- Choose all details for when and how often you want EasyCSV to fetch data from the Google Sheet you want.
- For the dropdown labeled "Where is the spreadsheet you want to fetch and import?" select "Google Sheets". It may be selected by default.
- Search for the name AND select the Google Sheet you want feteched on this schedule.
- Click "Save" at the bottom of the form.
- You are all set! Now, the Google Sheet will be fetched at the schedule specified and automatically imported by your import page.
How to set up a scheduled CSV or XLSX export for Airtable
Step-by-step Instructions
- Sign in to your EasyCSV Account
- Download a CSV file of your Airtable table data. You can do this by going to the tab with all your data in the Airtable base. Next to the view name (just under the tab name) there is a small, downward arrow. Click that little arrow and there is an option to download as a CSV file. Use this CSV to set up your import page and flow in the next step.
- Create an import page and flow by selecting an example CSV file of your Airtable data. You can also type out column headers.
- Once viewing your new import page click the "Scheduled Fetcher" link in the top nav.
- Click the button "New Scheduled Fetcher"
- Choose all details for when and how often you want EasyCSV to fetch data from Airtable.
- For the dropdown labeled "Where is the spreadsheet you want to fetch and import?" select "Airtable".
- Follow the directions on the page to put in the Airtable API info. There are helpful links connect Airtable. After connecting Airtable to EasyCSV you will be able to select the Airtable Base, Table, and View (optional).
- Click "Save" at the bottom of the form.
- You are all set! Now, the Airtable data will be fetched at the schedule specified and automatically imported by your import page. You can choose to send the data as a CSV file via email somewhere, upload to FTP as a CSV or XLSX file, upload to Dropbox, or anything else supported via EasyCSV as a destination for the data.
How to set up a scheduled fetcher for Google Drive CSV files
Step-by-step Instructions
- Sign in to your EasyCSV Account
- Create a spreadsheet import page by selecting an example CSV file or Google Sheet. You can also type out column headers of a spreadsheet you don't have at the moment. Usually using an example spreadsheet that is already made is the best way to go.
- Once viewing your new import page click the "Scheduled Fetcher" link in the top nav.
- Click the button "New Scheduled Fetcher"
- Choose all details for when and how often you want EasyCSV to fetch a matching CSV file from Google Drive.
- For the dropdown labeled "Where is the spreadsheet you want to fetch and import?" select "Google Drive".
- Enter a filename you want the scheduled fetcher to search for and fetch. The filename can be less specific to match more files. The scheduled fetcher will fetch the latest file by modified date that includes the filename text you specify. It will ONLY match and fetch files that are the mimetype 'csv'.
- Click "Save" at the bottom of the form.
- You are all set! Now, the Google Drive CSV file will be fetched at the schedule specified and automatically imported by your import page.
How to set up a scheduled fetcher for Dropbox
Step-by-step Instructions
- Sign in to your EasyCSV Account
- Create a spreadsheet import page by selecting an example CSV file or Google Sheet. You can also type out column headers of a spreadsheet you don't have at the moment. Usually using an example spreadsheet that is already made is the best way to go.
- Once viewing your new import page click the "Scheduled Fetcher" link in the top nav.
- Click the button "New Scheduled Fetcher"
- Choose all details for when and how often you want EasyCSV to fetch a matching CSV file from Dropbox.
- For the dropdown labeled "Where is the spreadsheet you want to fetch and import?" select "Dropbox".
- Enter a filename you want the scheduled fetcher to search for and fetch. The filename can be less specific to match more files. The scheduled fetcher will fetch the latest file by server modified date that includes the filename text you specify. It will ONLY match and fetch files that have the file extension '.csv'.
- Click "Save" at the bottom of the form.
- You are all set! Now, the Dropbox file will be fetched at the schedule specified and automatically imported by your import page.
How to set up a scheduled fetcher for Box
Step-by-step Instructions
- Sign in to your EasyCSV Account
- Create a spreadsheet import page by selecting an example CSV file or Google Sheet. You can also type out column headers of a spreadsheet you don't have at the moment. Usually using an example spreadsheet that is already made is the best way to go.
- Once viewing your new import page click the "Scheduled Fetcher" link in the top nav.
- Click the button "New Scheduled Fetcher"
- Choose all details for when and how often you want EasyCSV to fetch a matching CSV file from Box.
- For the dropdown labeled "Where is the spreadsheet you want to fetch and import?" select "Box".
- Enter a filename you want the scheduled fetcher to search for and fetch. The filename can be less specific to match more files. The scheduled fetcher will fetch the latest file by server modified date that includes the filename text you specify. It will ONLY match and fetch files that have the file extension '.csv'.
- Click "Save" at the bottom of the form.
- You are all set! Now, the Box file will be fetched at the schedule specified and automatically imported by your import page.
How to set up a scheduled fetcher for OneDrive
Step-by-step Instructions
- Sign in to your EasyCSV Account
- Create a spreadsheet import page by selecting an example CSV file or Google Sheet. You can also type out column headers of a spreadsheet you don't have at the moment. Usually using an example spreadsheet that is already made is the best way to go.
- Once viewing your new import page click the "Scheduled Fetcher" link in the top nav.
- Click the button "New Scheduled Fetcher"
- Choose all details for when and how often you want EasyCSV to fetch a matching CSV file from Microsoft OneDrive.
- For the options labeled "Where is the spreadsheet you want to fetch and import?" select "OneDrive".
- Enter a filename you want the scheduled fetcher to search for and fetch. The filename can be less specific to match more files. The scheduled fetcher will fetch the latest file by server modified date that includes the filename text you specify. It will ONLY match and fetch files that have the file extension '.csv' OR '.xlsx'.
- Click "Save" at the bottom of the form.
- You are all set! Now, the OneDrive file will be fetched at the schedule specified and automatically imported by your import page.
If you need to re-connect your OneDrive Account: Go to your connected apps on Microsoft - View your connected Apps, remove EasyCSV from your list of Apps, come back to EasyCSV and click here: Re-Connect Microsoft OneDrive
How to set up a scheduled fetcher for Amazon S3
Step-by-step Instructions
- Sign in to your EasyCSV Account
- Create a spreadsheet import page by selecting an example CSV file or Google Sheet. You can also type out column headers of a spreadsheet you don't have at the moment. Usually using an example spreadsheet that is already made is the best way to go.
- Once viewing your new import page click the "Scheduled Fetcher" link in the top nav.
- Click the button "New Scheduled Fetcher"
- Choose all details for when and how often you want EasyCSV to fetch a matching CSV file from Amazon S3.
- For the options labeled "Where is the spreadsheet you want to fetch and import?" select "Amazon S3".
- Enter the Access Key ID and Secret for an Amazon User via Amazon IAM. It is HIGHLY suggested you make a new Amazon IAM profile that has limited access to ONLY this bucket and folder path needed. The Amazon S3 permissions this new user will need are: s3:ListBucket, s3:GetObject.
- Enter the Bucket Name and the object key (path + filename) you want the scheduled fetcher to search for and fetch. The filename can be less specific to match more files. The scheduled fetcher will fetch the latest file by last modified date that includes the filename text you specify.
- Click "Save" at the bottom of the form.
- You are all set! Now, the Amazon S3 file will be fetched at the schedule specified and automatically imported by your import page.
How to set up a scheduled fetcher CSV or XLXS files from FTP / SFTP / FTPS
Step-by-step Instructions
- Sign in to your EasyCSV Account
- Create a spreadsheet import page by selecting an example CSV file or Google Sheet. You can also type out column headers of a spreadsheet you don't have at the moment. Usually using an example spreadsheet that is already made is the best way to go.
- Once viewing your new import page click the "Scheduled Fetcher" link in the top nav.
- Click the button "New Scheduled Fetcher"
- Choose all details for when and how often you want EasyCSV to fetch data from the FTP/SFTP/FTPS server, what folder the files are in, and the filename. By default, the fetcher will ONLY fetch files that end in .csv. To fetch XLSX files, simply end the filename with: .xlsx
- For the dropdown labeled "Where is the spreadsheet you want to fetch and import?" select "FTP/SFTP".
- Fill out the FTP/SFTP details for username, password, adress, etc... Default port number for FTP is 21 and for SFTP it is 22. If using these default ports you can leave that field blank.
- Click "Save" at the bottom of the form.
- You are all set! Now, the Google Sheet will be fetched at the schedule specified and automatically imported by your import page.
How to set up a scheduled fetcher for new Shopify Orders
Step-by-step Instructions
- Sign in to your EasyCSV Account
- Create an EasyCSV import page.
- Once viewing your new import page click the "Scheduled Fetcher" link in the top nav.
- Click the button "New Scheduled Fetcher"
- Choose all details for when and how often you want EasyCSV to fetch order data from Shopify.
- Choose if you want to treat each new Shopify Order as it's own import (great to make single order CSV files and send them somewhere) -or- group the data from many orders into one import (great if you need to send a grouped CSV file of many orders somewhere).
- Click "Save" at the bottom of the form.
- You are all set! Now, your scheduled fetcher will grab data for any new Shopify Orders on your schedule.
How to set up a scheduled fetcher for new Shopify Products & Variants
Step-by-step Instructions
- Sign in to your EasyCSV Account
- Create an EasyCSV import page.
- Once viewing your new import page click the "Scheduled Fetcher" link in the top nav.
- Click the button "New Scheduled Fetcher"
- Choose all details for when and how often you want EasyCSV to fetch product data from Shopify.
- Click "Save" at the bottom of the form.
- You are all set! Now, your scheduled fetcher will grab all your Product & Variant on schedule. You can then change this data into a CSV and send it somewhere or send the data to another app or API.
How to fetch on demand with a POST API request
** This feature is ONLY available on higher plan levels or custom plans. Reach our to EasyCSV support via Chat or Email if you need this feature **
- Go to your scheduled fetcher for your Import Flow or create one if needed.
- In the create or edit form there will be a section at the bottom of the form to allow Webhook fetches. Toggle that setting on.
- Copy the url shown for the POST request.
- Make the POST request to that unique URL for your fetcher with your API key as a param on the URL:
key value api_key your API key (get API key by clicking "Business Info" in the top nav after logging in) file_path (optional) ONLY for Amazon S3. Example: /invoices/new_invoice.csv
If this param is NOT passed the Fetcher will fetch the file from the file path + name in the Fetcher settings. If you need this param for other integrations please contact EasyCSV support via chat or email and we may be able to add it for you. - Check the fetch log table at the bottom of the Fetcher page to see results of the queued fetch.
- If you ONLY want to fetch via POST API request and not with a regular schedule as well then simply edit the fetch and at the bottom of the form leave the option to allow On demand fetching on BUT change the Fetcher On/Off Toggle to "OFF"