Allan Thraen
Nov 1, 2017
  3980
(5 votes)

Connect Episerver Forms with Google Sheets through Zapier - no code required

As some of you might know, I tend to do a lot of crazy projects - and sometimes I'm so busy doing them that I forget to share them. Luckily there are great like-minded people like Luc Gosso and Khurram Khan that produce posts which makes me think "uh..didn't I also do something like that some time ago" - and that's the perfect opportunity to get nostalgic and publish some of my older works.

Like today, reading Luc's post https://devblog.gosso.se/2017/11/save-data-from-episerver-forms-to-googlespreadsheet-with-webhooks/ I remember doing just that in a video I don't believe I published about 1 year ago. My approach didn't involve code - instead I was (and am) very happy using Zapier - a great integration platform, much like IFTTT and Microsoft Logic Apps. For years I've had a full Episerver / Zapier integration in the works, but this doesn't even require that. It's just plug and play with webhooks.

Also a shout out to Khurram, that also showcased Zapier back in 2016 here: https://world.episerver.com/blogs/K-Khan-/Dates/2016/3/zap-integration/ and did a super (from what I hear) presentation of Episerver and Logic Apps with Wessel Terpstra in Stockholm this fall (https://world.episerver.com/blogs/K-Khan-/Dates/2017/10/episerver-integration-with-azure-logic-apps/).

Anyway - here's the video I made (apologize for the sound quality - might be time for a new headset):

https://youtu.be/PZ7CSfCiqds

 

Nov 01, 2017

Comments

K Khan
K Khan Nov 2, 2017 10:02 AM

Thanks Allan,
https://world.episerver.com/blogs/K-Khan-/Dates/2016/3/zap-integration/

For your enterprise level solutions, Zapier may not be the best choice due to many reasons, but Logic App partially answers if we could use integration patterns with Logic App. though by nature Logic App also offers a linear workflow, For simple workflows Zapier is also a great choice.

Nov 2, 2017 12:50 PM

I love how you've become the webhooks guy Khurram... I remember back when that all started laughing

K Khan
K Khan Nov 2, 2017 05:08 PM

Thanks for reminding smile
http://www.markeverard.com/2015/11/11/using-webhooks-in-an-episerver-solution/

http://world.episerver.com/blogs/K-Khan-/Dates/2015/11/webhook-demo-server-and-alloy-client/

Please login to comment.
Latest blogs
Optimizely Web Experimentation Metrics

Within the domain of Optimizely Web Experimentation Metrics, the emphasis is on objective key performance indicators (KPIs) selected to assess an...

Matthew Dunn | Sep 23, 2023 | Syndicated blog

Optimizely For you Intranet

Having been at Optimizely and in the CMS industry for nearly 16 years I have seen clients’ intranet requirements go from a simple site just to hous...

Robert Folan | Sep 22, 2023

Vulnerability in EPiServer.GoogleAnalytics v3 and v4

Introduction A potential security vulnerability was detected for Optimizely Google Analytics addon (including EPiServer.GoogleAnalytics and...

Bien Nguyen | Sep 20, 2023

Overriding Optimizely’s Content Recommendations Block to Implement Custom Recommendations

Introduction The Content Recommendations add-on for Optimizely CMS dynamically recommends content from your site tailored to the interests of each...

abritt | Sep 13, 2023 | Syndicated blog

Developer contest! Install the AI Assistant and Win Bose QC45 Headphones!

We are thrilled to announce a developer contest where you have the chance to win a pair of Bose Headphones. The goal is to be the first developer t...

Luc Gosso (MVP) | Sep 7, 2023 | Syndicated blog

Send Optimizely notifications with SendGrid API, not SMTP

If your Optimizely site already sends transaction emails through an email platform API, why not do the same with Optimizely notification emails?

Stefan Holm Olsen | Sep 6, 2023 | Syndicated blog