Connecting to a Google Sheet

pillaccio 22 Aug, 2024

Is there a possibility to have a simple guide to connect a google sheet to a form? I have done all the possible and imaginable tests but without result. Thank you very much

Max_admin 23 Aug, 2024

yes, did you try to use the included Google sheets actions ?

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
pillaccio 24 Aug, 2024

thank you for reply. Yes, I entered the sheet id, tried all three methods in the write method field, tried different combinations with the range, created a JSON file and linked it in the Service Account JSON file path field, selected modify data source in the behaviors field, and tried different things with the form fields. Thanks.

Schermata 2024-08-24 alle 15.37.01.png
pillaccio 27 Aug, 2024

If it can help, in debug is wrote this. Thank you.

Array
(
    [google_sheets_write9] => Array
        (
            [data] => Array
                (
                )

            [response] => {
  "error": {
    "code": 400,
    "message": "Unable to parse range: Sheet1!A2:C2",
    "status": "INVALID_ARGUMENT"
  }
}
Max_admin 10 Sep, 2024

Your data is empty, you need to set a data source, and you better test with one row first, set the range to A1:Z1

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
You need to login to be able to post a reply.

VPS & Email Hosting 20% discount
hostinger