Automate export of Jira Form responses to Google Sheets (how to?)

[Barbara Shaw]

Hi! Members of our team have requested for a way to automate the export of form responses to a google sheet. At present, it's my understanding that unless we map every FORM field to a Jira field, form fields aren’t searchable through JQL query. The workaround I used is to run a JQL query for the form in advanced issue search e.g., Project = "project name" ORDER BY CREATED DESC
Selecting "Export XLSX (form data)" for the form from the export menu
Importing to Google sheet
Right now AFAIK there is not a way to automate this export and import without a plugin - correct? Any advice on how better to resolve this? Thanks!