Skip to content

Protsahan- Data writing to gsheets issue #87

@akanshaaa19

Description

@akanshaaa19

Summary

Issue Summary

Problem Statement: Data is not being written to the Google Sheet from the Protsahan Pilot- Menu flow.

Expected: Data should be written to the same Google Sheet but different tabs from both Protsahan Pilot flows (Central and Menu).

Actual Result: Data was sometimes written from the Central flow, but the Menu flow is unable to write data consistently.

Error Messages: No specific error messages were noted; however, there were issues previously that seemed to resolve randomly.

Reproduction Steps:

  1. Integrate Google Sheets write functionality within both Protsahan Pilot flows—make sure Central flow writes correctly.
  2. Attempt to write data from the Menu flow.
  3. Check if data appears in the assigned tab of the Google Sheet.

Additional Context: A prior issue with data writing in these flows was mentioned, but the related errors were deemed different.

Resolution Note: The cause of the issue was determined to be an invisible character in the subsheet name, which was corrected by re-entering the subsheet name. After this correction, writing functionality resumed.

Source

Original message

<@929190799151865956> <@1132952719586492478> Raising this issue on behalf of Protsahan.

Write to gsheet (same google sheet- different tabs) is integrated in 2 flows of Protsahan (Protsahan Pilot- Central flow, Protsahan Pilot- Menu). While data is getting written from one flow (Central flow), the other flow (Menu) isn't writing data inspite of the flow passing through that node. I just observed that 2 entries yesterday were written. But when i tested again now, it is not written. You can check my chat- https://pif.glific.com/chat/6319391

Please look into it. Please consider this as a P1 as it is data on on going pilot

Some background context0 There were data writing issues last week also for these flows, but it randomly got resolved. you can read about it here (though that error was different)- https://discord.com/channels/717975833226248303/1501525568099848363/1507004845956141118

cc- <@1470283924218445935>

Full thread transcript

krishna_glific: <@929190799151865956> <@1132952719586492478> Raising this issue on behalf of Protsahan.

Write to gsheet (same google sheet- different tabs) is integrated in 2 flows of Protsahan (Protsahan Pilot- Central flow, Protsahan Pilot- Menu). While data is getting written from one flow (Central flow), the other flow (Menu) isn't writing data inspite of the flow passing through that node. I just observed that 2 entries yesterday were written. But when i tested again now, it is not written. You can check my chat- https://pif.glific.com/chat/6319391

Please look into it. Please consider this as a P1 as it is data on on going pilot

Some background context0 There were data writing issues last week also for these flows, but it randomly got resolved. you can read about it here (though that error was different)- https://discord.com/channels/717975833226248303/1501525568099848363/1507004845956141118

cc- <@1470283924218445935>

Glific AI doc bot (bot): Hey! Thanks for flagging this—understood it’s P1 for the pilot.

Quick checks to unblock:

  • In Protsahan Pilot–Menu, please confirm the Link Google Sheet node is set to Action=Write, points to the same writable sheet, and uses the exact tab name (subsheet) and starting cell; also ensure the “Input data to update in sheet” is correctly mapped, as required in the write setup steps .
  • Please verify the Google service account used in Glific has Editor access on that spreadsheet; missing permission will prevent writes .

Could you share the exact tab name and a screenshot of that Google Sheet node configuration from the Menu flow? For reference, here’s the setup guide: Link Google Sheets.

I do not have sufficient info to answer this question. <@&1383715800632004648>, can you please chime in here?

Glific AI doc bot (bot): Was this helpful in resolving your query? Or do you need further support?

priyanshusingh3026: because of some reason there is a invncible character got add in the subsheet name in the google sheet node .i have reentered the subsheet name again it is working now .

avantikapif_19415: Thanks for raising this, <@1065224029218287707>. And for fixing it <@929190799151865956>.

Glific AI doc bot (bot): ✅ Ticket closed successfully!

Glific AI doc bot (bot): Please leave a quick rating to help us improve:

Metadata

Metadata

Assignees

Labels

Type

No type
No fields configured for issues without a type.

Projects

Status
Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions