1 of 1 people found this helpful
We do not have the appropriate permissions to fill the Google sheet directly from a Marketo form.
Well, you wouldn't be sending directly from the Marketo form, you send the form data to the Sheet via a webhook. It doesn't take any special perms and the whole process is described here: https://blog.teknkl.com/logging-marketo-form-fills-to-a-google-sheet/.
However, you don't necessarily need to farm this out to Sheets: that's a bit of a crutch, even though I wrote the above blog post!
The question, though, is what reporting you want to do in your "centralized location." You can use a webhook-based scripting engine (not a simple webhook, but an engine which you can find on LaunchPoint) to write form data to a Marketo Custom Object, one CO per fillout. API limits aside, this is extraordinarily flexible and truly stores a standalone snapshot of each form post.
However yet again, Marketo's reporting on COs (such as it is) is probably not up to your expectations. Namely, Smart Lists can filter on CO values but aren't designed to display/sort/group values as columns. So you'd end up pulling the COs back out again via the API to crunch the data, which means you might as well...
... pull the native Filled Out Form activities using the Bulk Activity Extract API and parse them. See, the system actually keeps a record (for 90 days) of each individual form fillout and its associated data. So it's already there, it just won't be reportable unless you dive into the Activity Logs offline.