Freshdesk is a customer support ticketing system that includes a range of ticketing tools such as ticket prioritization, service level agreements, native internal communication between collaborating agents, automated suggestions for ticket solutions and in-depth customer support analytics.
About Google Sheets
Google Sheets is an online spreadsheet app that lets users create and format spreadsheets while simultaneously working with other people. Businesses can use Google Sheets to maintain data consistency across departments and to ensure that every member of their team is on the same page.
Popular Use Cases
Bring all your Freshdesk data to Amazon Redshift
Load your Freshdesk data to Google BigQuery
ETL all your Freshdesk data to Snowflake
Move your Freshdesk data to MySQL
Bring all your Google Sheets data to Amazon Redshift
Load your Google Sheets data to Google BigQuery
ETL all your Google Sheets data to Snowflake
Move your Google Sheets data to MySQL
Freshdesk's End Points
Create, view, and/or modify information associated with one of your support agents, including their contact information (name, email, phone number), their permission level and which customer support group they belong to. You can also see if the agent is currently available to take a ticket and how long they have been available for so that you can assign tickets to appropriately.
Retrieve and update information about replies and notes associated with tickets, including the full text of the reply and the IDs of the agents, customer and support ticket associated with the conversation. This will not only allow you to integrate the full content of a support interaction into your customer support analytics but also allow Freshdesk to provide deeper analytics with regards to support agent performance.
See an array of information about a support ticket, including the customer that submitted the ticket, the source they submitted it from, the assigned agent, the content of the support request and the priority that Freshdesk has assigned that ticket. This, along with data about the type of support issue that the ticket is addressing, will allow you to more effectively assign the right members of your support team to the right tickets.
View data about a contact that has created a Freshdesk support ticket. This includes both basic contact information - like their name, email address, and social media ID - and information that will help you to more effectively assign the right agents to meet that contact’s needs, such as their preferred language, their associated tags and what other tickets they have submitted.
Google Sheets's End Points
Google Sheets Developer MetaData
Use developer metadata to keep track of a location or an object in a spreadsheet. This can help you maintain data organization and clarity, even as you scale or continue to add new rows of information.
Google Sheets Spreadsheets
Create new spreadsheets, look up existing spreadsheets via spreadsheet ID, or get data on portions of a spreadsheet using filters. These functions can help you understand and consolidate your data for big-picture business insights.
Google Sheets Values
Maintain full control over the values on your spreadsheet and add, clear, append, or update values as necessary. Use this flexibility to keep your data up-to-date and useful at all times.
Use sheets to copy a single sheet from a spreadsheet to another spreadsheet. This can be especially useful when you’re integrating data from various sources or reorganizing your data structure for analytics.