Auto-schedule imports from Google Sheets, Google Drive Files, Dropbox, or CSV files on FTP/SFTP servers

How to automate fetching Google Sheets, Google Drive, Dropbox, 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 Google Drive CSV files

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 a matching CSV file from Google Drive.
  6. For the dropdown labeled "Where is the spreadsheet you want to fetch and import?" select "Google Drive".
  7. 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'.
  8. Click "Save" at the bottom of the form.
  9. 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

  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 a matching CSV file from Dropbox.
  6. For the dropdown labeled "Where is the spreadsheet you want to fetch and import?" select "Dropbox".
  7. 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'.
  8. Click "Save" at the bottom of the form.
  9. 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 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.