TheWorkflowPro
TheWorkflowPro
  • 66
  • 32 073
Log to Google Sheets from Marketo without Zapier
theworkflowpro.com/marketo-google-sheets-integration/
Check out an easy way that you can send Marketo data directly to a Google Sheet without needing a middleman like Zapier and without needing to use the Google Sheets API, all in under 15 minutes.
มุมมอง: 78

วีดีโอ

Marketo Clearbit Integration in 20 Minutes
มุมมอง 83ปีที่แล้ว
theworkflowpro.com/clearbit-marketo/ This video will show you everything you need to know to set up Clearbit enrichment with Marketo.
Custom Marketo Lead Nurturing
มุมมอง 294ปีที่แล้ว
theworkflowpro.com/marketo-lead-nurturing/ Do you want to be able to customize your send times for your nurture programs so that you can do something like send email 1, send email 2 X days later, and send email 3 Y days after email 2? Also learn how you can create an email funnel so that people with multiple use cases can receive emails from multiple use case streams.
Identifying Bot Formfills in Marketo Using ChatGPT
มุมมอง 172ปีที่แล้ว
theworkflowpro.com/marketo-chatgpt-lead-classification Take a look at how you can use Marketo webhooks to send form fill information to ChatGPT to determine whether the form fill was made by a bot.
Great Use Cases for Marketo Tokens
มุมมอง 478ปีที่แล้ว
theworkflowpro.com/marketo-tokens/ Take a look at all the creative ways you can use Marketo tokens for saving time when building emails, webhooks, and smart campaigns.
Today's Date in Zapier Using Code & AI
มุมมอง 463ปีที่แล้ว
theworkflowpro.com/zapier-todays-date/ Check out how to use ChatGPT and Zapier's own "Generate with AI" function to generate code for a "Code by Zapier" action to do something simple like getting today's date.
Testing Marketo Custom Activities in Segment
มุมมอง 112ปีที่แล้ว
theworkflowpro.com/segment-marketo-integration/ See how you can use the Segment Schema and the Marketo Bulk Extract API to make sure that the counts for an event arriving in Segment match the counts you are getting in Marketo for the corresponding custom activity.
Person is Pushed to Marketo Trigger Explained
มุมมอง 167ปีที่แล้ว
theworkflowpro.com/person-pushed-marketo-trigger/ Demystify the "Person is Pushed to Marketo" trigger by seeing what it is, when to use it, and how to run this trigger from Postman and code.
ChatGPT API using Marketo Webhooks
มุมมอง 421ปีที่แล้ว
theworkflowpro.com/marketo-chatgpt-lead-classification See how to make requests to the ChatGPT API from within Marketo using webhooks and how you can update a lead with the information returned from ChatGPT.
Marketo Lead Scoring
มุมมอง 627ปีที่แล้ว
theworkflowpro.com/marketo-lead-scoring/ Take a look at 3 different models to assess lead quality, 1 model to score lead activities, and how you can use these models to power your MQL mechanism 00:00 Introduction 00:49 Demo & Firmo Model 1 06:33 Demo & Firmo Model 2 18:47 Demo & Firmo Model 3 30:54 Activity Model 35:07 MQL Model 39:23 Next Up
Marketo Lead Classification with ChatGPT
มุมมอง 468ปีที่แล้ว
theworkflowpro.com/marketo-lead-scoring/#Demo_Firmo_Marketo_Lead_Scoring_Model_3 See how you can classify leads created in Marketo by using Zapier to make requests to ChatGPT and then update the Marketo lead with the ChatGPT classification.
Marketo ICP Matching
มุมมอง 112ปีที่แล้ว
theworkflowpro.com/marketo-lead-scoring/#Demo_Firmo_Marketo_Lead_Scoring_Model_1 See how to translate customer profiles into corresponding Marketo fields and build smart campaigns that assess newly created leads to see how good a fit they are for your company.
Marketo Demo & Firmo Grading
มุมมอง 95ปีที่แล้ว
theworkflowpro.com/marketo-lead-scoring/#Demo_Firmo_Marketo_Lead_Scoring_Model_2 Learn how to grade the values a person has for different demographic and firmographic fields in Marketo to yield a single output grade that you can use for your marketing qualification mechanism.
Marketo Activity Tracking
มุมมอง 165ปีที่แล้ว
theworkflowpro.com/marketo-lead-scoring/#Marketo_Lead_Scoring_for_Activity See how we can score the different activities we have in Marketo and add these scores together over a certain time period to gauge a person’s level of intent.
Marketo MQL Mechanism
มุมมอง 105ปีที่แล้ว
theworkflowpro.com/marketo-lead-scoring/#MQL_Model_Outline Learn how to build an MQL mechanism in Marketo to alert sales and provide them with the context about why a lead was deemed to be marketing qualified.
Marketo Email Template Quick Start
มุมมอง 2.6Kปีที่แล้ว
Marketo Email Template Quick Start
Marketo Destination Overview in Segment
มุมมอง 114ปีที่แล้ว
Marketo Destination Overview in Segment
Marketo Custom Activity Deep Dive
มุมมอง 231ปีที่แล้ว
Marketo Custom Activity Deep Dive
Segment CDP Walkthrough
มุมมอง 687ปีที่แล้ว
Segment CDP Walkthrough
Nested Looping in Zapier using Code by Zapier
มุมมอง 285ปีที่แล้ว
Nested Looping in Zapier using Code by Zapier
Edit More Than 500 Rows in Google Sheets Using Nested Looping in Zapier
มุมมอง 191ปีที่แล้ว
Edit More Than 500 Rows in Google Sheets Using Nested Looping in Zapier
Nested Looping in Zapier using Webhooks
มุมมอง 121ปีที่แล้ว
Nested Looping in Zapier using Webhooks
Nested Looping in Zapier using Google Scripts
มุมมอง 67ปีที่แล้ว
Nested Looping in Zapier using Google Scripts
Importing Google Sheets Rows in Zapier
มุมมอง 1.4Kปีที่แล้ว
Importing Google Sheets Rows in Zapier
Import more than 10MB in Zapier from Google Sheets
มุมมอง 126ปีที่แล้ว
Import more than 10MB in Zapier from Google Sheets
Import More Than 500 Rows from Google Sheets to Zapier
มุมมอง 363ปีที่แล้ว
Import More Than 500 Rows from Google Sheets to Zapier
Sub Zap By Zapier
มุมมอง 278ปีที่แล้ว
Sub Zap By Zapier
Updating Marketo Period Costs via API
มุมมอง 92ปีที่แล้ว
Updating Marketo Period Costs via API
Marketo Lead Routing with Chili Piper
มุมมอง 117ปีที่แล้ว
Marketo Lead Routing with Chili Piper
Marketo Enrichment with Number Lookup
มุมมอง 53ปีที่แล้ว
Marketo Enrichment with Number Lookup

ความคิดเห็น

  • @Motivations_Matters
    @Motivations_Matters 14 ชั่วโมงที่ผ่านมา

    Hey hi bro your videos are good please help me out with one requirement I have on requirement: Ziflow and Asana automation When a New proof is created in Ziflow with multiple reviewers based on that reviewers count tasks need to be created in asana and assignees as reviewers in the proof each task should assign each reviewer

  • @HughMcMahon-nm1ig
    @HughMcMahon-nm1ig 18 วันที่ผ่านมา

    Great vid. Can you use tokens anywhere in Smartlist logic? I've a feeling I can't and I'm completely blocked by it

  • @feetsnyardscom
    @feetsnyardscom 2 หลายเดือนก่อน

    Hi great video, I filled out the form but didn’t get the postman collection. My name is Robin

    • @theworkflowpro
      @theworkflowpro 2 หลายเดือนก่อน

      Hi Robin, nice to meet you. There is a small charge for the API collection now. Once you pay this you should receive an email with a link to download the collection. All the best

  • @mikekyle007
    @mikekyle007 3 หลายเดือนก่อน

    Can you clone an executable campaign, via API (and keep it executable)?

    • @theworkflowpro
      @theworkflowpro 3 หลายเดือนก่อน

      Yes, if you set the "isExecutable" parameter in the body to "True" it will keep it as executable. Same for when creating smart campaigns you can make them executable using the same parameter

  • @paulschlereth5101
    @paulschlereth5101 3 หลายเดือนก่อน

    quick question: does mktoNumber have to have a unit assigned? I can envision using that to assign an image width or height attribute which assumes pixels but does not include it as part of the attribute value.

    • @theworkflowpro
      @theworkflowpro 3 หลายเดือนก่อน

      Hi Paul, specifying a unit is optional: experienceleague.adobe.com/en/docs/marketo/using/product-docs/email-marketing/general/email-editor-2/email-template-syntax#number

  • @MrAbstractj
    @MrAbstractj 3 หลายเดือนก่อน

    I love your thorough walkthrough. Were the ZoomInfo phone numbers selectively verified by Sales as valid phone numbers or simply based on the three-way comparison logic table?

    • @theworkflowpro
      @theworkflowpro 3 หลายเดือนก่อน

      Thanks @MrAbstractj. The ZoomInfo phone numbers were not verified by Sales, only by the comparison in the Google sheet

  • @atchayaa3897
    @atchayaa3897 4 หลายเดือนก่อน

    is there any way achieve this without looping

    • @theworkflowpro
      @theworkflowpro 4 หลายเดือนก่อน

      Hi there, theworkflowpro.com/zapier-google-sheets/ you can check out this blog post. It depends on how much data/rows you are trying to bring into Zapier

  • @AkAshwinkumar
    @AkAshwinkumar 5 หลายเดือนก่อน

    Thank you:)

  • @carlomatiga
    @carlomatiga 6 หลายเดือนก่อน

    This information is GOLD! Thanks for this! Subscribed!

    • @theworkflowpro
      @theworkflowpro 6 หลายเดือนก่อน

      Thanks Carlo, I'm glad it's useful!

  • @Vijay-nu5pc
    @Vijay-nu5pc 6 หลายเดือนก่อน

    I want to lock a file using my local dropbox path. But it didn.t work.

  • @nav6593
    @nav6593 6 หลายเดือนก่อน

    how practice if i dont have my own website

  • @BrandonHull
    @BrandonHull 6 หลายเดือนก่อน

    Can you do a lookup that is fuzzy? Or at least that is based more off a "contains" approach than an exact match?

    • @theworkflowpro
      @theworkflowpro 6 หลายเดือนก่อน

      Hi Brandon, you can't do this within Zapier natively but there is a workaround in this community post: community.zapier.com/show-tell-5/finding-rows-in-google-sheets-that-contain-a-lookup-value-no-code-8460

  • @KyleKelly-gh6kp
    @KyleKelly-gh6kp 6 หลายเดือนก่อน

    Hello, I am getting an error on line 31 of the send nesting TypeError: Cannot read properties of undefined (reading '0'). i have a 3 column spreadsheet, i tried only removing references to the phone/4th column, but i continue to get this error, please assist

    • @theworkflowpro
      @theworkflowpro 6 หลายเดือนก่อน

      Hi Kyle, please send your contact info by filling out this form: theworkflowpro.com/workflow-pro-bio/

  • @gabrielaruelas1628
    @gabrielaruelas1628 7 หลายเดือนก่อน

    Have you ever used Stripo's Marketo export function, not the HTML? If so, does it reduce the marketofy coding when you set it up?

    • @theworkflowpro
      @theworkflowpro 7 หลายเดือนก่อน

      I imagine so but I have never used the Marketo export function since we do not pay for that feature. This would be a good question to ask their sales team/support or in the marketo community. Post back here if you get an answer please!

    • @gabrielaruelas1628
      @gabrielaruelas1628 7 หลายเดือนก่อน

      @@theworkflowpro I have the paid version, which can export and "marketofy" the template to some extent. But if I want to have some local variables available, I have to be more specific in the marketo tags and still adjust the template.

    • @theworkflowpro
      @theworkflowpro 7 หลายเดือนก่อน

      @@gabrielaruelas1628 got it thanks for sharing!

  • @chelseahonnens
    @chelseahonnens 7 หลายเดือนก่อน

    Thank you! One of the only videos I found that actually explain this well.

  • @MahaBenabboud
    @MahaBenabboud 7 หลายเดือนก่อน

    Thank you for this video!

  • @fear_the_youth
    @fear_the_youth 8 หลายเดือนก่อน

    really cool content Tyron! I know variables make it simple for users to manage items like button text in the editor but I just started stripping our all our text string variable as they are not picked up automatically by the plain text editor (which forces you to uncheck the "automatically update from HTML" box and can sometimes lead to discrepancies between the HTML and the plain text). For this reason, I have using rich text for all text output variables (where leaving styling values such as colors, numbers, etc as variables). Just wanted to call it our as a consideration (pro or con) of things like using variables to append utms to the end of URLs. Cheers!

    • @theworkflowpro
      @theworkflowpro 7 หลายเดือนก่อน

      Thanks for sharing that, I didn't know the impact of variables on plain text emails, hopefully others will see this comment and it can help them too

  • @meganorsi8591
    @meganorsi8591 8 หลายเดือนก่อน

    Is it possible to create global "modules" that can be used in different email templates in Marketo? For instance, a two-column layout with an image on one side, and text on the other.

    • @theworkflowpro
      @theworkflowpro 8 หลายเดือนก่อน

      Hi Megan, no it is not possible to have global modules across templates. You will have to copy the module code from one template to another. Email building tools like Stripo do have global modules that you can use when building your templates so I build in Stripo and then import the code into Marketo

    • @meganorsi8591
      @meganorsi8591 8 หลายเดือนก่อน

      @@theworkflowpro Thank you for the quick response! I'm just starting to learn the ins and outs of Marketo. Watched a few tutorials, consulted Google - I was surprised when I couldn't find anything on the topic. I guess that's why; You can't do it!

    • @theworkflowpro
      @theworkflowpro 8 หลายเดือนก่อน

      @@meganorsi8591 I have lots of blogs on Marketo to help you on your learning journey: theworkflowpro.com/category/marketo/ Here is also a Marketo Fundamentals playlist: th-cam.com/video/RmrIsIEugx0/w-d-xo.html&pp=gAQBiAQB And here are all my Marketo videos: th-cam.com/video/moY2Z0dUm4A/w-d-xo.html&pp=gAQBiAQB

  • @JanWszolek2
    @JanWszolek2 9 หลายเดือนก่อน

    Hey is there a way where you could help me with that??

    • @theworkflowpro
      @theworkflowpro 9 หลายเดือนก่อน

      Nice to meet you Jan. Submit your information here and we can talk about this project: theworkflowpro.com/workflow-pro-bio/

  • @atahandemir5956
    @atahandemir5956 10 หลายเดือนก่อน

    Hello, just trying my luck with something similar. I'd love if you could help me. I am trying to loop the my Sheets rows that has "NO" and zap them automatically until there's none left. I was thinking about going through all YES/NO once the zap is initiated, add all NO's to the array, and initialize the zap on the rows that were added to the array but I cant figure out how to successfully achieve. If you can help it'd be great. love your content, learnt so much

    • @theworkflowpro
      @theworkflowpro 10 หลายเดือนก่อน

      Hi there, nice to meet you. If you fill out this form: theworkflowpro.com/workflow-pro-bio/ I can get your details and take a look. Please share a loom video or other screen recording so I can see what you are trying to achieve

  • @mohangr3703
    @mohangr3703 10 หลายเดือนก่อน

    Hey, Do you write in LinkedIn?

  • @vVthinkhardVv
    @vVthinkhardVv 11 หลายเดือนก่อน

    This was a really helpful video. Thanks! Subscribed and bookmarked.

    • @theworkflowpro
      @theworkflowpro 11 หลายเดือนก่อน

      Thank you, I'm glad it was helpful. Happy holidays!

  • @fredericlamontagne3812
    @fredericlamontagne3812 ปีที่แล้ว

    Amazing you helped me a lot

    • @theworkflowpro
      @theworkflowpro ปีที่แล้ว

      No worries I'm glad you found it helpful Frederic!

  • @AGC07
    @AGC07 ปีที่แล้ว

    Great video! Very helpful!

    • @theworkflowpro
      @theworkflowpro ปีที่แล้ว

      Thank you, I'm glad you found it helpful!

  • @CodeSource179
    @CodeSource179 ปีที่แล้ว

    Do you have a video on Dynamic content within Marketo Emails using the variable Html Block Data-type?

    • @theworkflowpro
      @theworkflowpro ปีที่แล้ว

      theworkflowpro.com/marketo-dynamic-email-content/ In this blog post I share how to update the dynamic content HTML email blocks via API

  • @HeatherWilliamson-w1n
    @HeatherWilliamson-w1n ปีที่แล้ว

    Has anyone found another place to get the unique webinar ID besides the zoom confirmations? Ideally we wouldn’t want to have the emails turned on and then off again.

  • @AnneWilliams-c3f
    @AnneWilliams-c3f ปีที่แล้ว

    Super helpful, thanks!

  • @lelandmorgan6055
    @lelandmorgan6055 ปีที่แล้ว

    😜 *Promo SM*

  • @christophermarin
    @christophermarin ปีที่แล้ว

    Your tutorials are fantastic!

    • @theworkflowpro
      @theworkflowpro ปีที่แล้ว

      Thanks Chris, I'm glad you found it useful!

  • @theworkflowpro
    @theworkflowpro ปีที่แล้ว

    While I am using Google Scripts here you can apply the same logic I use to any system external to Zapier e.g. scheduled scripts in any programming language, your marketing automation platform, your customer data platform, etc, where you can do the nested looping outside of Zapier to send a maximum of 500 rows at a time to Zapier for processing

  • @ejthorson
    @ejthorson ปีที่แล้ว

    🔥🔥🔥

  • @life_with_masa
    @life_with_masa ปีที่แล้ว

    very informative. Tnx for sharing your knowledge.

    • @theworkflowpro
      @theworkflowpro ปีที่แล้ว

      Thanks Madhav, I'm glad you found it helpful!

  • @fabianmirandapalma4979
    @fabianmirandapalma4979 ปีที่แล้ว

    You are the best! Saved me a ton of time!!

    • @theworkflowpro
      @theworkflowpro ปีที่แล้ว

      I am so glad you found this useful Fabian!

  • @mahakmundra2617
    @mahakmundra2617 ปีที่แล้ว

    Superb explaination, thank you so much !!

    • @theworkflowpro
      @theworkflowpro ปีที่แล้ว

      I'm glad this was helpful for you @mahakmundra2617

  • @mahakmundra2617
    @mahakmundra2617 ปีที่แล้ว

    This was Wonderful. Thank you !

    • @theworkflowpro
      @theworkflowpro ปีที่แล้ว

      You are very welcome @mahakmundra2617

  • @ejthorson
    @ejthorson ปีที่แล้ว

    Love it! Great work man 💪

  • @nursenkadakal4366
    @nursenkadakal4366 ปีที่แล้ว

    Great content, thank you for sharing!

    • @theworkflowpro
      @theworkflowpro ปีที่แล้ว

      Thanks for the positive vibes @nursenkadakal4366!

  • @TheVideosofJulien
    @TheVideosofJulien ปีที่แล้ว

    This is awesome, thank you so much for sharing! Quick question, how are you able to group your tokens?

    • @theworkflowpro
      @theworkflowpro ปีที่แล้ว

      @TheVideosofJulien I presume you mean the grouping between Local and Inherited tokens (if not then please let me know the time in the video where you see the grouping). The local tokens section contains all the tokens you create at the program level, whereas if you have a folder containing a bunch of programs and you create tokens at this folder level then all the programs within this folder will inherit these tokens and they will appear in the inherited section. If you change any of the inherited tokens then they will appear in the "Overridden" section. Does this answer the question?

  • @KayJohnsonArt
    @KayJohnsonArt ปีที่แล้ว

    Thank you. This is very clear and helpful.

    • @theworkflowpro
      @theworkflowpro ปีที่แล้ว

      thanks @iLearnTrain, I'm glad you found it helpful!

  • @theworkflowpro
    @theworkflowpro ปีที่แล้ว

    Thanks for the kind words Jessie, I love it when people find my content helpful and it gives me the drive to keep producing more content!

    • @JessieObeng
      @JessieObeng ปีที่แล้ว

      One thing to consider for the analysis is Crunchbase does have firmographic and demographic information now. I'm not sure if it wasn't present at the time of doing this

    • @theworkflowpro
      @theworkflowpro ปีที่แล้ว

      @@JessieObeng thanks for sharing this Jessie, I wasn’t aware that Crunchbase now has demographic information!

  • @JessieObeng
    @JessieObeng ปีที่แล้ว

    This was such a thorough and detailed analysis, Tyron. I was literally about to begin my own analysis and then stumbled on your blog post. Excellent work!

  • @daAdiYogi
    @daAdiYogi 2 ปีที่แล้ว

    hi there, is there a way to extract the custom object data only through Marketo API

    • @theworkflowpro
      @theworkflowpro ปีที่แล้ว

      Hi Revanth, you should be able to use the Bulk Custom Object Extract api for this: developers.marketo.com/rest-api/bulk-extract/bulk-custom-object-extract/

    • @daAdiYogi
      @daAdiYogi ปีที่แล้ว

      @@theworkflowpro Thank you , but this bulk custom object extract will extract the data present in those custom objects or will it only extract the custom objects

    • @theworkflowpro
      @theworkflowpro ปีที่แล้ว

      @@daAdiYogi I have never used the Bulk Custom Object Extract api before so you will have to do some testing with the api to find out the answer to your question. If you do find the answer please comment here so others can learn from this in future

  • @Andrew-eb2qt
    @Andrew-eb2qt 2 ปีที่แล้ว

    🌺 𝕡𝕣𝕠𝕞𝕠𝕤𝕞

  • @theworkflowpro
    @theworkflowpro 2 ปีที่แล้ว

    I was a bit under the weather for this one (and beaten down by these frustrating issues haha) so sorry for the lack of enthusiasm!

    • @pierreflovie6165
      @pierreflovie6165 8 หลายเดือนก่อน

      Hey Tyron, did you managed to find what the issue was? This is a massive concern if data gets nulled or campaign does not complete due to the merge I'd say. Attribution results is what the business wants to see and has to be accurate.

    • @theworkflowpro
      @theworkflowpro 8 หลายเดือนก่อน

      @@pierreflovie6165 check out this blog post: theworkflowpro.com/marketo-attribution-model/

    • @pierreflovie6165
      @pierreflovie6165 8 หลายเดือนก่อน

      @@theworkflowpro thanks Tyron for this.

  • @theworkflowpro
    @theworkflowpro 2 ปีที่แล้ว

    While what I show in the video above was intended to delay the organic social, referral, and search campaigns by different amounts, it turns out that people who qualify for smart campaigns while anonymous will not go through wait steps in these campaigns when they become known (see nation.marketo.com/t5/product-documents/anonymous-lead-promotion-to-known-lead-munchkin-v2-behavior/ta-p/250613). However, the mere presence of these wait steps in the organic campaigns means that they will be deprioritized in Marketo's campaign queue compared to the paid campaigns resulting in the paid campaigns always being processed first and getting the first opportunity to claim attribution on a person (see theworkflowpro.com/marketo-campaign-priority-override). However, beyond this, all organic campaigns will be deprioritized to the same extent so there is no way to prioritize organic social and referral above the hungry organic search campaigns like Google. If you want to be able to set up a priority order for attribution campaigns to run (e.g. Paid then Social then Referral then Search) then you will need to use executable campaigns and a centralized model, which will be explained in a future post.

  • @iliyanslavov6751
    @iliyanslavov6751 2 ปีที่แล้ว

    Really great tips. Insightful video

    • @theworkflowpro
      @theworkflowpro 2 ปีที่แล้ว

      Thanks Iliyan, comments like these keep me going!

  • @theworkflowpro
    @theworkflowpro 2 ปีที่แล้ว

    I highly recommend watching the "Automatic Marketo Duplicate Merging with Zapier" video first because this is where I explain a lot of the merging logic and it will also be easier to follow: th-cam.com/video/uW7WN8fn9DQ/w-d-xo.html

  • @eindbaas
    @eindbaas 2 ปีที่แล้ว

    Do you still have the postman collection? It says it's binned when I try to subscribe

    • @theworkflowpro
      @theworkflowpro 2 ปีที่แล้ว

      Hi Sylar, thanks for the heads up. I've fixed the redirect on the form now. I have emailed you the link to download the Postman collection. Happy building!

  • @tomaskvapil2821
    @tomaskvapil2821 3 ปีที่แล้ว

    great video! It helped me a lot. Thanks

    • @theworkflowpro
      @theworkflowpro 3 ปีที่แล้ว

      Thanks Tomas! I appreciate you letting me know that, feedback like this gives me the motivation to keep making more content