Allan Thraen
Nov 1, 2017
  4394
(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
Increase timeout for long running SQL queries using SQL addon

Learn how to increase the timeout for long running SQL queries using the SQL addon.

Tomas Hensrud Gulla | Dec 20, 2024 | Syndicated blog

Overriding the help text for the Name property in Optimizely CMS

I recently received a question about how to override the Help text for the built-in Name property in Optimizely CMS, so I decided to document my...

Tomas Hensrud Gulla | Dec 20, 2024 | Syndicated blog

Resize Images on the Fly with Optimizely DXP's New CDN Feature

With the latest release, you can now resize images on demand using the Content Delivery Network (CDN). This means no more storing multiple versions...

Satata Satez | Dec 19, 2024

Simplify Optimizely CMS Configuration with JSON Schema

Optimizely CMS is a powerful and versatile platform for content management, offering extensive configuration options that allow developers to...

Hieu Nguyen | Dec 19, 2024

Useful Optimizely CMS Web Components

A list of useful Optimizely CMS components that can be used in add-ons.

Bartosz Sekula | Dec 18, 2024 | Syndicated blog

SaaS CMS - Pages and Blocks get the Visual Builder Treatment

I’m thrilled to see that Optimizely has now enabled Visual Builder for OG Pages and Blocks within SaaS CMS, and I’m guessing this will become...

Minesh Shah (Netcel) | Dec 17, 2024