Google スプレッドシートとリスト(or スマートリスト)の連動は可能か?(Is it possible to link Google spreadsheets with a list or smart list?) | Community
Skip to main content
Koki_Enomoto
Level 3
September 12, 2018
Question

Google スプレッドシートとリスト(or スマートリスト)の連動は可能か?(Is it possible to link Google spreadsheets with a list or smart list?)

  • September 12, 2018
  • 1 reply
  • 3782 views

【日本語/Japanese】

いつもお世話になっております。GEです。

Marketoのリスト(またはスマートリスト)のリード情報をGoogleスプレッドシートと連動・同期させ、それをGoogleスプレッドシートへ書き出すことは可能ですか?

また、Googleスプレッドシートの情報を書き換えた場合、それらをMarketoに同期させることは可能ですか?

【英語/English】

I'm GE.

Is it possible to link / sync lead information of Marketo's list (or Smart List) with Google Spreadsheet and export it to Google Spreadsheet?

Also, if you rewrite information on Google spreadsheets, is it possible to synchronize them with Marketo?

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

1 reply

SanfordWhiteman
Level 10
September 12, 2018

Is it possible to link / sync lead information of Marketo's list (or Smart List) with Google Spreadsheet and export it to Google Spreadsheet?

Yes, via webhook.  You can push directly to a Sheet as shown in Logging Marketo form fills to a Google Sheet or can update the Sheet via an intermediate webhook gateway (which can apply more intelligence if necessary).

Also, if you rewrite information on Google spreadsheets, is it possible to synchronize them with Marketo?

Depends on what you want to do.

You can easily update lead fields via a webhook, if the lead already exists in the sheet in some fashion. Just look up in the Sheet and pass back the result. This is something we do often to enrich leads.

But you can't create new leads via webhook. You have to pull the sheet down into a CSV and import it, or use another method to integrate the platforms.