Technical issue resolving running query to update the records from Jira into our google sheets

[Niraj Sonkusare]

When typing the JQL query on the google spreadhseets - > Extensions -> Jira cloud for sheets

extension -> (project = FN AND created >= "2026-01-01" ORDER BY created DESC) to refresh the data for this specific sheet , the sheet throws an error and we do not have an updated records of Jira in the excel.

How can we see the issue here ? How can we solve this issue ? This formula works well for the same sheet and other tab. 

[Paul Glantschnig [Appfire]]

Hey @Niraj Sonkusare and welcome to the community :) 

Since the same JQL works in another tab of the same sheet, the query itself is fine — this is a Sheets extension issue, not a JQL issue, as already mentioned by Himanshu.
A few more things to try:

1. Check the error message. The Jira Cloud for Sheets extension usually shows a specific error (authentication expired, rate limit, field access issue). 

2. Re-authorize the connection. Go to Extensions > Jira Cloud for Sheets > Settings and disconnect, then reconnect your Jira instance. Token expiry is a common cause, especially if the working tab was set up earlier with a fresh token.

3. Check for sheet-level differences. Sometimes a tab has leftover data validation rules, protected ranges, or conditional formatting that conflicts with the extension writing data. Try running the import in a brand-new blank tab to isolate this.

4. Check issue count. If the FN project has a very large number of issues matching that filter, the extension may be timing out on that specific tab (if the other tab has a narrower date range or fewer results). You can test by adding a tighter filter like AND created >= "2026-03-01" to reduce the result set.

5. Google Sheets API quotas. If you're running multiple Jira imports across tabs simultaneously, you might be hitting Google's API rate limits. Try running the import on just the failing tab with no other imports active.

If none of that resolves it, the Jira Cloud for Sheets extension has its own support channel — it's worth raising a bug there with the specific error details.

Separately — if the reason you're pulling data into Google Sheets is to get a spreadsheet-like view of your Jira issues (sorting, filtering, editing in a table), you might be interested in JXL for Jira, the app my team and I are building.

JXL gives you a full spreadsheet/table view directly inside Jira — with inline editing, sorting, filtering, copy-paste, and export to XLSX/CSV. It eliminates the need for a Google Sheets sync pipeline for many use cases, since the data is always live and editable in place.

Disclosure: I work for the team that builds JXL.

Cheers,
Paul

[Himanshu Tiwary]

Hi @Niraj Sonkusare ,
this might be a Sheets add-on/tab issue than a JQL issue, especially since the same query works in another tab.
I would suggest try these steps 1.Click Open in Jira and run the same JQL there first, If it works in Jira, the query is fine Then 2.create a new tab or new sheet and run the import again, Also try reconnecting the Jira Cloud for Sheets extension then use your JQL to test the things