I am using Python and gspread to upload local .csv data to a google *SpreadsheetA*.
I have a separate google *SpreadsheetB* that uses =IMPORTRANGE to import the data from Spreadsheet A and create a pivot table and corresponding chart. If I were to manually adjust any data in SpreadsheetA (e.g., alter value of any cell, add a value to an empty cell, etc), then the data in SpreadsheetB—with its corresponding pivot table and chart—update dynamically with the new data from SpreadsheetA. However, when SpreadsheetA is updated with new data programmatically via Python, IMPORTRANGE in SpreadsheetB does not capture the new data. Any ideas as to why this happens and how I might be able to fix? -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-spreadsheets-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/252bda8f-1061-4489-ae47-14f6007ec518n%40googlegroups.com.