Hello,
I have not seen a viable solution for this so posting it for discussion.
We are working with another company on a campaign and they are sending their email capture leads to a Google Sheet. We want to send those email addresses (and other info like first and last name) from that Google Sheet into to our Marketo instance. Ideally, they would fall onto a static list in Marketo, so we could then run the "added to list" trigger.
Has anyone found a way to do this?
Thanks in advance!
You can do this with tools like Talend, Boomi, Zapier...which use the API integration and allow you to point it at sheets and define the processing.
Beyond Josh's suggestions, you could also cut out the middle man by using Google Apps Script to send Sheets data over to Marketo as it comes in.
To Josh List, I can add Workato, with which we had some good experience.
-Greg