Hey, I’m hoping to make weekly updates the one of my spreadsheets and have those updates reflected in the app. When I add new rows in google sheets I’m not seeing any updates even after syncing the app. Any suggestions?

I’ve figured it out. Even though the google sheet saves automatically, you have to refresh the page and then sync the app.

I did find the Delta Sync, turned it on and the 5 new rows on my google sheet are still not showing in the app. The spreadsheet does not have external formulas.

Is it possible that you don’t have any value in your key column? Or maybe doubles?

I have one primary key, no doubles and no errors

Have you checked that the spreadsheet is the same?

Yes, the spreadsheets are the same. When I open this table and click “view source”, the spreadsheet launches and I can see the new data I’ve added that has not been synced with the app.

I deleted the table in question and re-added it which allowed me to update the app from the spreadsheet one time. I added another row and clicked sync and the app will not update any further. It also would not remove the new row in the app when I deleted it in the spreadsheet.

It seems to me that AppSheets will play nice when data is appended but it stops syncing when rows are removed from the source data. I’m almost certain that once I delete a row and try to sync thats what is throwing the app off. Can you confirm if that’s by design or maybe a bug?

You should not need to do that. If you change something on the gSheet, the sync should be enough.

I was working on my app 2 days ago without any issues and come back today and can’t get one of my tables to show the data in the gsheet Gsheet: [3X_d_1_d177af55d0c18540e4c50d41925d41b3f6156572.png] Table in Appsheet: [3X_f_4_f40cd890c57a20617619909e512ef94c3d87e32c.png] The table columns look…

Spreadsheet updates not showing in app

AppSheet AppSheet Q&A

Steve January 30, 2021, 5:41pm 15

Probably best, then, to engage support@appsheet.com. Someone will probably have to look under the hood, so to speak.

Topic		Replies	Views
Data Does Not Update When Spreadsheet Is Updated AppSheet Q&A databases	10	51	September 17, 2020
New app, connected to gsheets, data never updates AppSheet Q&A databases , errors	5	29	October 7, 2021
app sheet table not getting updated while google sheet is updated AppSheet Q&A app-management	7	49	June 16, 2023

Spreadsheet updates not showing in app

AI Suggested topics