To provide some context, I have successfully connected my app to Google Sheets, and under normal circumstances, the data interaction functions smoothly. However, I have observed that when dealing with larger volumes of data, modifications made within the table interface do not reflect immediately after saving. Instead, the displayed data remains unchanged, despite the fact that the updates have been applied to the Google Sheet itself.
Could you please advise on how I can ensure that modifications made to the data within the table interface are promptly reflected, particularly when handling larger datasets?