Marketo + Google Sheet Hack for Online Event Management

0 1I wanted to share a Marketo hack that we just implemented at my company in case it is helpful for you as well. Big shout out to my web developer for discovering and implementing this solution!

Problem:

As many of our offline events are turning virtual, my team is being slammed with webinar projects (really testing that Marketo <> Webex integration here). Additionally, all of our marketing business partners want a consolidated place to list all of their webinars (because, why wouldn’t you?) and to also be able to update “Register” links with “Watch Video” links post event.

Additionally:
  • Constant changes to webinar dates and times
  • Tons of new additions/deletions
  • Updating of old events to include recorded link, etc
When you potentially multiple this by 6 business units, multiple languages and any number of “webinar sets” you can see how this simple ask was starting to give me night sweats.
Solution:
  • Connect a Google Sheet to a Marketo LP
  • Share edit access to the Google Sheet with the marketing business partner
  • Have them maintain their own page (each column in the Google sheet is one of the rows in the LP

Join the community to learn more about the details behind this hack.

Code Source: https://github.com/CarlaAstudillo/feats_thru_sheets

About The Author — Naomi Liu
Naomi Liu

Related free workshops

Button in Google Sheets to trigger a Google Script to send multiple rows to Zapier

Zapier Import Multiple Rows from Google Sheets

Anyone who has worked with Google Sheets in Zapier is likely to have run into the issue of needing to import more than the 20-row maximum imposed when using the Google Sheets app. This post will show you how to overcome this limitation and import multiple rows from Google Sheets into Zapier using some JavaScript and webhooks.

Become a member

MarketingOps.com Launches Career and Community Platform for Marketing Operations Professionals

Community-led platform offers networking opportunities, career development tools, and educational resources for more than 3,000 “MO Pros” IRVINE—MarketingOps.com, a new platform for marketing operations professionals, launched today. The website aims to serve the 12 million global professionals in the industry—starting with the 2,800 members of the existing MO Pros community:

Become a member
Zapier nested looping horizontal flow diagram

Zapier Nested Looping using Webhooks & Python

Banging your head against the wall because of the 500 iteration limit on the “Looping by Zapier” action? Well make like Freddie Mercury and break free by using webhooks and Python in Zapier to achieve nested looping so that you can do as many iterations as you need!

Become a member