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.

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 don't have at the moment. Usually using an example spreadsheet that is already made is 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 don't have at the moment. Usually using an example spreadsheet that is already made is 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 don't have at the moment. Usually using an example spreadsheet that is already made is 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 Box

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 don't have at the moment. Usually using an example spreadsheet that is already made is 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 Box.
  6. For the dropdown labeled "Where is the spreadsheet you want to fetch and import?" select "Box".
  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 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

  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 don't have at the moment. Usually using an example spreadsheet that is already made is 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 Microsoft OneDrive.
  6. For the options labeled "Where is the spreadsheet you want to fetch and import?" select "OneDrive".
  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' OR '.xlsx'.
  8. Click "Save" at the bottom of the form.
  9. 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 clieck here: Re-Connect Microsoft OneDrive

How to set up a scheduled fetcher CSV or XLXS files from 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 don't have at the moment. Usually using an example spreadsheet that is already made is 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, 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
  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.