Summary
Problem Statement: Google Sheet read operation in the Glific application is not functioning as expected.
User Expected: The user expected to read data from a linked Google Sheet successfully.
What Actually Happened: The reading operation from the Google Sheet failed, as indicated by the user’s complaint, but specifics were not provided regarding any error messages.
Error Messages: No error messages were mentioned in the thread.
Reproduction Steps:
- Link a Google Sheet in Read mode within the Flows section of the Glific application.
- Ensure the first column header is labeled "Key" and that it contains unique, non-blank keys.
- Check whether the “Select row” in the Link Google Sheets node correctly matches a key format (like 1 or @calendar.current_date).
- Ensure that any date formats in the sheet are set to DD/MM/YYYY.
- Click Sync on the sheet to attempt a data read.
Additional Information: The user did not provide the specific flow name or the Google Sheet, which would be necessary for further diagnosis or assistance.
Source
Original message
My read to google sheet is not working
Full thread transcript
priyanshusingh3026: My read to google sheet is not working
Glific AI doc bot (bot): Hi there! Could you please share the flow name and the Google Sheet you’ve linked so I can check specifics?
Meanwhile, try these quick checks:
- In Flows > Google Sheets, confirm the sheet is added in Read mode and is accessible (share it with your service account or set “Anyone with the link can view”)
- Ensure the first column header is Key, there are no blank keys, and each Key is unique; otherwise reads and sync will fail
- In your Link Google Sheets node, check “Select row” matches a Key (e.g., 1 or @calendar.current_date). If using a date, format the sheet’s dates as DD/MM/YYYY
- Click Sync on the sheet and test again; if you see a sync error on the Google Sheets page, use the FAQ to resolve it
Helpful docs:
Glific AI doc bot (bot): Was this helpful in resolving your query? Or do you need further support?
Summary
Problem Statement: Google Sheet read operation in the Glific application is not functioning as expected.
User Expected: The user expected to read data from a linked Google Sheet successfully.
What Actually Happened: The reading operation from the Google Sheet failed, as indicated by the user’s complaint, but specifics were not provided regarding any error messages.
Error Messages: No error messages were mentioned in the thread.
Reproduction Steps:
Additional Information: The user did not provide the specific flow name or the Google Sheet, which would be necessary for further diagnosis or assistance.
Source
Original message
My read to google sheet is not working
Full thread transcript
priyanshusingh3026: My read to google sheet is not working
Glific AI doc bot (bot): Hi there! Could you please share the flow name and the Google Sheet you’ve linked so I can check specifics?
Meanwhile, try these quick checks:
Helpful docs:
Glific AI doc bot (bot): Was this helpful in resolving your query? Or do you need further support?