Connect Freshdesk API to Google Sheets

Howdy everyone! 


API Connector is a Google Sheets Add-On that allows you to connect any endpoint from the Freshdesk to Sheets. For example, this is how you would retrieve your open tickets:


1) Get your API key from the "Profile Settings" screen in Freshdesk.


2) Copy the following URL into "API URL Path" inside API Connector: https://your_domain.freshdesk.com/api/v2/tickets


3) Base64 encode your API key by appending :X on the end and using this tool


4) Set your key:value headers as Authorization: Basic {encoded}


4) Run your request to get your data in Google Sheets!


image


The tool is free with optional paid upgrade. For a more detailed tutorial, head over to our Knowledge Base article. Hope this tool is helpful for y'all!

Login or Signup to post a comment