[Marketing] Use URL Logger for your own Cloud based low code solution

Problem Statement

Using Gravity Forms , when we upload files to them , all files are stored by default on company servers, let's say Firkee.com in our case. If we use Dropbox or Gdrive add-on for gravity forms  , Webhooks sadly are fired immediately and then processing to dropbox or Gdrive happen. This means , Webhooks will always have files from Firkee.com , and these links are deleted by Dropbox/Gdrive Addon

As of July 2024 , gravity forms refuses to solve this , the "hack" is to install php code for each webhook for each form for each field , it gets very messy very quickly. 

Other Solutions

• Use Zapier / Make / n8n - All solutions cost money ,are step based , another SAAS in picture. A Bare minimum package from them is $25/month or more.
• Hire Wordpress developers which can help you achieve this - The costs is already running in $300+
• Sync mySQL table to local drive with a sync - Gravity forms syncs data across multiple tables , solution exists but it's tedious

Enter URL-Logger

• URL logger is a node.js based solution by ETL-tools for only $100 , it's wicked fast and writes everything to a SQL / sqlite database of choice
• All the gravity forms now send a webhook to URL-logger , say myserver.com/gdrive_upload
• URL Logger has a facility to trigger scripts , whenever data hits , these scripts can run async or detached without waiting for script to finish.
• We use a simple python script , made by ChatGPT which reads the
  • json from MS-SQL,
  • find all links inside json ,
  • download the file ,
  • uploads the file to Gdrive,
  • Updates the Json file with gdrive link
  • Send the link to wherever you want 

Thoughts

• This is a very customised solution to a customised problem , but works great for us
• This took us around 3 hours to figure , 2.5 hours went in breaking head with ChatGPT to write the script and test it. 
• Having URL Logger , with it's solid capability to receive webhbookos quickly, and customized end points , allows us to dream of a solution like this.
• No need for another SAAS ! Obviously if you are accepting 50 webh-ooks per second, then we need a queueing mechanism and we must use Packages to solve this.
• If we want logs, then we can use packages to achieve the same. Team ETL , let me know if we can use Cloud Storage package instead to upload files(but I have large accounts on gdrive  1TB+, that's my issue)

PS

• Does it sound like a sales pitch ! It is , URL Logger is amazeballs