Skip to main content

Dear Team,

Is there any way we can fire a new email from google sheet? Like, in the google sheets there are different fields - to email, subject, content..Then clicking a button (or something like that), email will be fired to the recipient and a ticket will be created (may or may not reflect back on the Google sheet).

There is an application/Google Sheet addon, called Mail Merge. But that shoots emails directly from the gmail id. So that does not create a ticket number. I want to have the ticket number generated.

Looking forward to your help.

 

Regards,

Amitav 

Hi @AmiChat ,

 

Greetings from freshworks community.

Request to use the API method to create whenever a google sheet row or Column data is filled, the Create ticket API can be invoked for creating ticket. You can refer this link on the API Payload information and authentication methods - https://developer.freshdesk.com/api/#create_ticket

 

Cheers


Reply