If you have a Google Spreadsheet that is being updated with new data, you can directly export it to Faraday.
You can "Publish to the web" as a CSV and Faraday will import it every day.
Check required information
Here's an example of what the raw data might look like: https://docs.google.com/spreadsheets/d/11Ehgf04GXQQKBL7Cow5v8X-vExYLfyIzH463qFNYhVE/edit?usp=sharing
You need to "Publish to web":
Make sure you select the sheet, CSV format, and automatically republish:
If you try the secret URL you should get something like this:
$ curl 'https://docs.google.com/spreadsheets/d/e/2PACX-1vTNQS_cYbvMk33uTlHYESDzl73LWYiCjL_xps3KBrM5eUfERg4O1p7aUmmJ2l6wVm1jGKg_BlfCHshc/pub?gid=0&single=true&output=csv'
Seamus,Abshere,1038 E Dayton St,Madison,WI,53703,6082551734,firstname.lastname@example.org,2018-09-29,site visit
Seamus,Abshere,1038 E Dayton St,Madison,WI,53703,6082551734,email@example.com,2019-02-01,contract signed
Seamus,Abshere,1038 E Dayton St,Madison,WI,53703,6082551734,firstname.lastname@example.org,2019-03-01,cancelled
Then you can put this secret URL into https://app.faraday.io/settings/integrations
If you have multiple URLs, please separate them with a comma.