SOLVED

Writing from a form to a google sheet with Marketo

Go to solution
Level 2

Writing from a form to a google sheet with Marketo

Is there a way to write information that comes in for a program via a form to a google sheet? I want to track traffic sources on a per program basis. I have the UTM parameters set up as described on other postings in this forum (first touch, multi touch, last touch). But I need a copy of the information for specific programs (so that the source information won't be changed or appended to the point of being illegible). 

 

The process: We have a webinar registration global form. It is embedded on specific pages, for example a landing page for Webinar X. We use UTM parameters to track traffic sources, for example linkedin (source) ad (medium). If Person Doe (who is already a lead in Marketo/SFDC) registers for Webinar X, this information along with the UTM parameters gathered as hidden fields on the form, is immediately written to a google sheet. Then when Person Smith registers, their information is added to the row below Doe's on the same sheet. 

 

Thoughts? Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Level 10 - Community Moderator

Re: Writing from a form to a google sheet with Marketo

3 REPLIES 3
Highlighted
Level 10 - Community Moderator

Re: Writing from a form to a google sheet with Marketo

Highlighted
Level 2

Re: Writing from a form to a google sheet with Marketo

Thank you! This looks brilliant. @SanfordWhiteman I'm attempting to set it up now. Do you know if it would be possible to have a separate tab in the sheet for each program?   

Highlighted
Level 10 - Community Moderator

Re: Writing from a form to a google sheet with Marketo

I don't think it's possible to change the destination sheet on-the-fly like that. But Apps Script could presumably move the rows from sheet to sheet based on a ProgramId column.