Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

how to set up a field that is connected with google sheet

Ben Chen I'm New Here Jul 21, 2021

when l input any value in a field, the system could, for example, automatically vlookup the value with the external google sheets

1 answer

0 votes
Dario B Atlassian Team Jul 22, 2021

Hello @Ben Chen ,

Welcome to the Atlassian Community!

I am not sure I understand correctly, are you trying to load data from Google Sheets into a custom field in Jira or the other way around?

If it is the other way around (load data from Jira into Google Sheets), then there is the free app Jira Cloud for Google Sheets developed by Atlassian that might fit your needs:


If you want to load data from Google Sheets into Jira Cloud instead, then I am afraid there is no OOB way to do so. However, you may want to search for 3rd party apps available in our marketplace that might allow you to do so:


I hope this helps.



Ben Chen I'm New Here Jul 22, 2021

Hi Dario


Many thanks for your advice!

The application in the link of Atlassian Marketplace may help me a lot. Anyway, l will have a research here to find any function that could help me.


Thanks again~


Yours sincerely


Like Dario B likes this
Dario B Atlassian Team Jul 23, 2021

You are very welcome @Ben Chen . 

Also, in case of any doubt, you can contact the vendors and ask for more details on what is possible to achieve using their apps 

Have a nice weekend!


Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence

👁‍🗨 Confluence Team planning dashboard_Atlympics 🌈

Hi Atlassian's, How is your journey with #Atlympics 2021 so far....excited! Me too, same excitement. Here's my typical team planning and vision dashboard which I used to share to my management and ...

105 views 1 5
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you