When a tag (basic enriched) is added in GHL to contacts, it sends data over the webhook. This webhook then make sure that contacts and its company information is stored with all its property in the NoCoDb database. This automation was an effort to migrate all the enriched contacts and their information in a central database in NoCoDb

When the GHL contacts tags changes, it sends the data to webhook This webhook then processes tags and makes sure that all the tags are created or updated in the NoCoDB

When triggered from a webhook based button in Sheets, it clears the Google Sheet, read all the tickers form another Google Sheet and then fetches the Google Trends results for all the tickers At the end, it stores the tickers google trends data into the Google Sheet.

This is a connection between Alloware (a calling software) to BigQuery It is processing multiple items in parallel. Alloware sends all its events over the webhook. These events are then sent to BigQuery. Using custom BigQuery SQL queries and views, the dashboards for the performance of calling agents were then made. Complete case study at Case Study: Alloware Sales Team Performance Tracker in Google Sheets

It is a part of HR automation for an automation agency. It is triggered when a new case study is submitted in a Notion database. It gets the candidate information from Applicants database and matches based upon email. It then updates the applicants status to Case Study Submitted . Also creates a link between candidates row in applicant database and case study database.

A meeting summarization automation that even I am using as well. When ever a new meeting recording drops in a specified drive folder, it sends the file to OpenAI Whisper API for transcription. Once transcription is generated, it can be sent to any tool or destination, for example processing it for creating minutes of meeting using GPT API.

This automation using a custom API call to Alloware (calling software) gets list of all the calling agents (Users) Inserts the updated Users in BigQuery table.

Kixie (a dialer similar to alloware) was also connected to BigQuery. Kixie would send event data to two different webhook. One for end call event and other for sms events. The data was then stored in BigQuery in relevant tables.

Automatically generate seo-friendly content for wordpress through DeepSeek R1 by giving input ideas on how to structure the article. A cover image is also generated and uploaded with OpenAI DALL-E 3.

This automation get triggered every Monday on 9 AM and retrieves Google Analytics data from the last 7 days. It transforms the data, calculates aggregates, fetches previous year data on same dates and sends to Open AI in tabular form to generate a detailed report. It then sends the report to email and a short message in the telegram.