Create/Update Google Sheet from Marketo Static List | Community
Skip to main content
RaulEr
RaulEr
New Participant
May 23, 2023
Solved

Create/Update Google Sheet from Marketo Static List

  • May 23, 2023
  • 2 replies
  • 2069 views

Hi community,

 

I was trying the Zapier app to send data from Marketo to Google Sheets but the only available trigger is when a new lead is created in Mkto.

Are there any other ways to do this? Maybe a webhook or another integrations platform?

 

Thanks!

 

-Raul

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

If you follow the directions I linked above, it’s pretty easy to append rows.

 

If you must overwrite rows in the Sheet (rather than appending new rows and using another Sheet as a “rollup view” to show one row per Email Address) then you can’t use a simple form post. Instead, you’d need to call a webhook-compatible service that in turn calls the Google Sheets API to update cells.*

 

 

 

*Technically, every Google Form has an unguessable ‘Edit Link’ that lets a person go back and
edit their answers after each form post. Very handy when using a visible Google Form, but
when skipping the visible form to POST straight to the form endpoint, it’s not feasible to get
the Edit Link from the response. If you had the Edit Link you could POST updates to that but alas.

2 replies

SanfordWhiteman
SanfordWhiteman
New Participant
May 24, 2023

You can add rows to a Google Sheet using a Google Form-style post — read my old post on that. Then you can use the approach suggested here to read only the latest row for each person.

Darshil_Shah1
Darshil_Shah1
Community Manager
May 24, 2023

When do you wish to trigger an update in the sheet - on new people getting added to/existing people getting removed from the list, or existing people getting updated, or both?

 

 

RaulEr
RaulErAuthor
New Participant
May 24, 2023

Both. I would need to reflect all changes from the static list into the sheet.

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
May 25, 2023

If you follow the directions I linked above, it’s pretty easy to append rows.

 

If you must overwrite rows in the Sheet (rather than appending new rows and using another Sheet as a “rollup view” to show one row per Email Address) then you can’t use a simple form post. Instead, you’d need to call a webhook-compatible service that in turn calls the Google Sheets API to update cells.*

 

 

 

*Technically, every Google Form has an unguessable ‘Edit Link’ that lets a person go back and
edit their answers after each form post. Very handy when using a visible Google Form, but
when skipping the visible form to POST straight to the form endpoint, it’s not feasible to get
the Edit Link from the response. If you had the Edit Link you could POST updates to that but alas.

    Terms & ConditionsAccessibility statement

    Loading footer...