We will automate the creation of help desk tickets using data from an Excel sheet.
In this project, once the bot is invoked, it will check whether there are new request files available to process. If available, the bot will read the ticket data from this spreadsheet. The data is then used to create support tickets in the Zoho Desk application.
Here is the high-level workflow for the project:
We believe it should take you around 1 hour to build and run this first project. Obviously, the amount of time it will take will vary depending on your background.
Now, let's dive into the details and step through the creation of the automation.
