We are using the Formidable Forms plugin with the Google Sheets addon and we would like to add a hook before the entries are sent to Google Sheets. Our goal is to call an external API to retrieve additional data and then write this data in the hidden fields of the entry before it is sent to Google Sheets.
We have attempted to use the "frm_after_create_entry" hook, but due to the 1-minute delay in the API call, the user is forced to wait before being redirected to the "success-page."
Is there a solution that would allow us to continue using the Google Sheets addon while also incorporating the external API call? T he only solution we have come up with is to create a cron job to retrieve new entries, call the external API, and then send the entries to Google Sheets, but this requires a lot of coding and we would prefer to avoid it if possible.
Thank you for your assistance!