You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a process that uploads a sheet with about 25 MB worth of data when formatted into a Google Sheets API compatible object (the actual data itself is about 3 MB when exported as CSV).
When trying to use Export-GSSheet on this data, I receive the following:
Hey @ConnorGriffin - Thanks for opening this up! Looks like Google has a 10MB limit on multiple API's of theirs and that's what you're running up against 😞
Definitely going to see if I can build in some logic underneath Export-GSSheet to allow a workaround, but for now you can get around this by splitting your array from the imported CSV into quarters or thirds and iterating through and using the -Append flag on the rows after the first that don't need the header row to be re-pasted. Working on getting you an example now, give me a bit 😃
Seems like it wouldn't be hard to add a recursive call, just re-using the existing code with the -Append switch. I'll test it out when I get a chance next week.
I have a process that uploads a sheet with about 25 MB worth of data when formatted into a Google Sheets API compatible object (the actual data itself is about 3 MB when exported as CSV).
When trying to use Export-GSSheet on this data, I receive the following:
The text was updated successfully, but these errors were encountered: