It used to be a challenge getting anonymous data from the web into SharePoint. Webhooks make this integration much easier.
What’s a webhook? SendGrid defines it as:
A webhook (also called a web callback or HTTP push API) is a way for an app to provide other applications with real-time information. A webhook delivers data to other applications as it happens, meaning you get data immediately
Connecting Gravity Forms with SharePoint Online
Wouldn’t it be great to connect Gravity Forms and SharePoint so you can act on forms submissions from your WordPress site? This blog post will cover the steps to make this happen and you can look at the video of this process, too.
Get a Gravity Forms / WordPress Trial
Go to https://www.gravityforms.com/demo/
Be sure to activate the webhooks add in the WordPress site.
We’ll use the multi page form sample – as you can see there are many other forms you can try.
Create a few entries – note – we aren’t using email confirmations.
Export the entries to a csv file
Open the csv and save it as an Excel file – one thing I missed in the video was inserting a table in the spreadsheet of the exported entries. This would make importing the spreadsheet a little bit easier.
Import the Excel file into SharePoint. Make sure you use IE 11!
You can watch the video or review this article from Microsoft – https://support.office.com/en-us/article/create-a-list-based-on-a-spreadsheet
Configure the Webhook TimeStamp 4:14 in video
1 – Go to https://webhook.site/ and copy the unique URL and paste it into the request URL below and select update settings
Create a form submission and go back to https://webhook.site/ to view the response.
You’ll see the key is not descriptive
Go back to the webhook page – this time next to “Request Body” change the option to “Select Fields” and provide a descriptive key.
Create another form entry and submit
You’ll see the data is much easier to understand – make sure you select the most recent submission (1)
Copy the entire JSON response to the clipboard (2)
Go to Power Automate
Create a new flow, automated, from blank. Then search http in the trigger. Video Timestamp 7:03
Paste the JSON response from earlier into the sample payload area.
Add a new step in your Flow – Create a SharePoint list item
Populate the field values from the box on the right
Step 3 – Copy the URL of the http request
Step 4 – Go to https://urldecode.org/ and paste the URL you copied in step 3, then select decode
Step 5. Update the webhook URL in Gravity Forms with the decoded value from the previous step
Create another form entry
Verify flow created the new list item
You can do many things with webhooks – this is an example to get you started