Intake Requests Without Form

I am trying to see if there is a way to create rows via email without having our employees use a form.

We are currently receiving a large amount of requests from our branch personnel to our corporate office. These are specific requests for a specific department. The requests are currently coming into our Jira help-desk via email to support (support@companyname) and assigned to our team's queue to complete. Although we want to track these requests and get them as soon as possible, these are requests to be completed in the future and based on the date provided in the body of the email. ALSO, we won't actually be completing them until a new employee starts in a few weeks JUST for these tasks. SO, to manage these we are manually adding them to our Smartsheet for tracking and then closing the Jira ticket so as not to violate our SLAs. We're talking 60+ requests from 20 branches a day to a very small team, in addition to an already considerable workload. We're spending way to much time on a process that I could somewhat automate if it weren't for my permission and user access levels.

I have looked at all of the solutions below with no success;

  • Jira Excel Export & Import 2 Smartsheet- Jira export errors due to internal configuration with no ETA on the ticket I submitted regarding the export error
  • Jira & Smartsheet Integration- Denied by sys admin
  • Smartsheet add on for Outlook- API not supported - Denied by sys admin
  • Zapier- Denied by sys admin
  • Provide Smartsheet submission form- Denied, cannot ask submitter/s to deviate from the process used for all requests (support@companyname)

I am looking for a way to circumvent the form and have emails sent to (support@companyname) with a specific phrase add a row to tracking sheet.

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Lindsey,

    Interesting!

    Unfortunately, as far as I know, it's not possible at the moment to add a row through email (without plugin or third-party service), but it's an excellent idea!

    Please submit an Enhancement Request when you have a moment to have your vote added

    It seems like all third-party options aren't possible because of the sysadmin. Correct? Why?

    That makes it difficult and possibly impossible to create a viable solution!

    Possible workarounds, you could drag and drop the mail to the sheet (untested) or create a pdf for each request and drag that over to the sheet.

    Would that work/help?

    I hope that helps!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    ✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer! 

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.