Is there a API to create JIRA tickets from google sheet

[praveenmetturnatarajan]

Lets say if there are 100 rows of user stories in a google sheet and these has to be converted into individual JIRA tickets. Is there an API to start with from the basic integration of google sheet and JIRA? And then write a function to create JIRA tickets from each row?

[Bhushan Nagaraj]

@praveenmetturnatarajan ,

There are a couple of solutions that address this requirement.

https://zapier.com/apps/google-sheets/integrations/jira

https://automate.io/integration/google-sheets/jira

Atlassian APIs to create an issue is documented at https://developer.atlassian.com/server/jira/platform/jira-rest-api-examples/#creating-an-issue-examples

Regards

Bhushan

[praveenmetturnatarajan]

Thanks Bhusan! I will take a look.