Freshdesk-Make.com-ChatGPT-Airtable Integration

We are looking for an experienced automation specialist to set up a trial integration connecting the following platforms:

Freshdesk – to monitor ticket creation and updates
Make.com – as the core automation engine
OpenAI (ChatGPT API) – for generating smart responses
Airtable – to filter and pull structured data based on client input
Google Sheets – to log system actions and responses for audit/tracking


---

Scope of Work (Trial Phase):

1. Trigger the automation when:



A new ticket is created in Freshdesk

An existing ticket is updated by the requester (not the agent)


2. Send the relevant ticket content to ChatGPT using custom prompts



ChatGPT should interpret filters like number of units, duration, category, etc. (exact filter fields will be provided)


3. ChatGPT should return a formatted response based on structured data stored in Airtable (pulled dynamically)


4. The response should be posted to Freshdesk as an internal note


5. Each action (ticket ID, filters used, GPT response, timestamp) must be logged in Google Sheets




---

ChatGPT Prompt Logic Includes:

Context-aware replies (using full ticket thread)

Professional tone

B2B-oriented wording (writing as if responding to a company, not end-user)

Custom tagging logic based on predefined rules (e.g., large volume or urgency flags)



---

Deliverables:

Fully working Make.com scenario

Integration of all platforms as described

10 test tickets processed successfully

Logs visible in Google Sheets

Short Loom/video walkthrough of setup



---

Please apply only if you have proven experience with Make.com and API-based automation. This is a trial project; successful execution will lead to long-term work on expanding the system.