Auto-schedule imports from Google Sheets or CSV files on FTP/SFTP servers

How to automate fetching Google Sheets or CSV files and import to any app or API.

How to set up a scheduled fetcher for Google Sheets

Step-by-step Instructions

  1. Sign in to your EasyCSV Account
  2. 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 dont' have at the moment. Usually using an example spreadsheet that is already made it the best way to go.
  3. Once viewing your new import page click the "Scheduled Fetcher" link in the top nav.
  4. Click the button "New Scheduled Fetcher"
  5. Choose all details for when and how often you want EasyCSV to fetch data from the Google Sheet you want.
  6. For the dropdown labeled "Where is the spreadsheet you want to fetch and import?" select "Google Sheets". It may be selected by default.
  7. Search for the name AND select the Google Sheet you want feteched on this schedule.
  8. Click "Save" at the bottom of the form.
  9. 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 FTP / SFTP / FTPS

Step-by-step Instructions

  1. Sign in to your EasyCSV Account
  2. 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 dont' have at the moment. Usually using an example spreadsheet that is already made it the best way to go.
  3. Once viewing your new import page click the "Scheduled Fetcher" link in the top nav.
  4. Click the button "New Scheduled Fetcher"
  5. Choose all details for when and how often you want EasyCSV to fetch data from the FTP/SFTP/FTPS server where the file is located.
  6. For the dropdown labeled "Where is the spreadsheet you want to fetch and import?" select "FTP/SFTP".
  7. 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.
  8. Click "Save" at the bottom of the form.
  9. You are all set! Now, the Google Sheet will be fetched at the schedule specified and automatically imported by your import page.