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

Please see http://knowledgebase.faraday.io/help-and-support/data-sources/what-fields-are-required-when-sending-data-to-faraday

Setup

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'
first_name,last_name,address,city,state,zip,phone,email,date,status
Seamus,Abshere,1038 E Dayton St,Madison,WI,53703,6082551734,seamus@faraday.io,2018-09-29,site visit
Seamus,Abshere,1038 E Dayton St,Madison,WI,53703,6082551734,seamus@faraday.io,2019-02-01,contract signed
Seamus,Abshere,1038 E Dayton St,Madison,WI,53703,6082551734,seamus@faraday.io,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.

Thanks!

Did this answer your question?