Hello,
Our issue is updating an existing Google spreadsheet whenever a WP all-export PRO file is created (see link: https://prnt.sc/AW8r0g24kFid). We've set up a ZAP for this. It works by replacing the old file in our Google Drive with the newly exported WP all-export PRO file (in Excel or CSV format), making it accessible to all users.
However, we need the data from the CSV/Excel file to be directly uploaded or replaced in an existing Google spreadsheet. I tried using the Formatter action, but we're dealing with tables of 2000 to 10,000 rows, which is problematic. Is there another way to automatically transfer the data from the WP all-export PRO file to the Google spreadsheet and update the existing spreadsheet with the same name as the export?
The goal is that the Google spreadsheet always stays the same, with the same link, but the data should be updated on each WP all-export PRO file with the same name.
Thanks!
