Writing from a form to a google sheet with Marketo | Community
Skip to main content
T
tina-5
Level 2
May 21, 2020
Solved

Writing from a form to a google sheet with Marketo

  • May 21, 2020
  • 1 reply
  • 2844 views

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

Hi Tina,

 

Here's a blog post on that very subject: https://nation.marketo.com/t5/Product-Blogs/Logging-Marketo-form-fills-to-a-Google-Sheet/ba-p/242855

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
May 21, 2020

Hi Tina,

 

Here's a blog post on that very subject: https://nation.marketo.com/t5/Product-Blogs/Logging-Marketo-form-fills-to-a-Google-Sheet/ba-p/242855

T
tina-5Author
Level 2
May 22, 2020

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?   

SanfordWhiteman
SanfordWhiteman
Level 10
May 22, 2020

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.

    Terms & ConditionsAccessibility statement

    Loading footer...