With the sigma export to Google Sheets functionality, will sigma export the table to the same sheet every time and re-write the data or generate a new sheet with every export?
There are three options for exporting to Google Sheets/Drive if you export to google sheets then it will just be a snapshot of your data as a Google Sheet (each time you select Data Export -> Google Sheets it will create a new sheet). If you decide to send this as a schedule it will overwrite that Google Sheet every time it is scheduled to send. If you send to Google Drive it will be sent to a folder, and if you send it as a schedule each time it will make a new sheet in that folder! Check out these help docs for some more information!