Bachelor Tech
  • Home
  • Tutorials
  • Portfolio
  • About Jan
  • Contact Jan

Dynamically Populate Gravity Forms from Google Sheets (GSheets APIv4)

by Jan Bachelor March 16, 2021
1.1k views

Last Updated on March 16, 2021 by Jan Bachelor

In this tutorial, we will create a Google API key, install required software on our web server via SSH.

We will then download contents from GSheets (APIv4) and pass on the requested values into Gravity fields using Gravity API (GFAPI).

Part 1 – Get GSheets API working with your WordPress instance

Lessons

Create a Google Service Account + Key Install Composer + Google API Client (Linux) Utilize Composer to talk to Google Sheets API Use GSheets APIv4 in WordPress using the Code Snippets plugin

Part 2 – Examples for loading GSheets into Gravity Forms

Lessons

Example 1a: Purchase orders – load a list of clients into a Gravity Forms dropdown from a GSheet Example 1b: Purchase orders – load a list of projects from a GSheet based on the previously selected clients into a Gravity Forms dropdown
0 comment 0 FacebookWhatsappEmail
Jan Bachelor

previous post
Build Your Own Router – Proxmox, OPNSense, OpenVPN server and a VPN client all in one!
next post
Create an automated Gravity workflow that will allow users to request admin rights for their Macs in JamF Pro using Integromat and JamF API.

Search for articles

Other Tips

  • How to mount an NFS share (such as from FreeNAS) from an Android box
  • How to download a Windows 10 ISO on a Windows device – easy work-around

Other Tutorials

  • Build Your Own Router - Proxmox, OPNSense, OpenVPN server and a VPN client all in one!
    12 Steps
  • Dynamically Populate Gravity Forms from Google Sheets (GSheets APIv4)
    6 Steps

Recent Comments

  • Jan Bachelor on Use Integromat to get computer IDs from user email in JamF ProHi Robert, the static groups were created in the p…
  • Robert Petitto on Use Integromat to get computer IDs from user email in JamF ProCan you share how you'd use Make (integromat) to a…
  • Martin on Part 1 – What do we want to do + Required technology (bank feed)This tutorial deserves more credit, I've not seen…
  • Jan Bachelor on WAN / LAN Set Up (Before OPNSense Installation)Hi Ed, I have not tested it with PCI passthrough y…
  • Ed on OPNSense VM Set UpIn step 4 firewall you turned off firewall, should…

Tags

chrome iso windows

Categories

  • Android
  • FreeNAS
  • Linux
  • Windows

Recent Posts

  • How to mount an NFS share (such as from FreeNAS) from an Android box

  • How to download a Windows 10 ISO on a Windows device – easy work-around

Facebook Twitter Instagram Pinterest Linkedin Youtube

@2019 - All Right Reserved. Designed and Developed by PenciDesign

Bachelor Tech
  • Home
  • Tutorials
  • Portfolio
  • About Jan
  • Contact Jan