I’m using the integration “Add new paid Shopify orders to a Google Sheets spreadsheet”.
Right now this Zap is pulling all my new paid orders from Shopify and putting each order in a new Row inside the selected worksheet.
What I want to do now is create for each day a new worksheet named after the current day and put in that worksheet all the corresponding orders for that day.
E.g.: If today is 15 Jun and 15 Jun I had 3 orders. Create a new worksheet named 15 Jun and put all the orders for that day, keep updating the orders until 15 Jun has ended and do the same for the following day. All in the same Spreadsheet, only adding worksheets.
Hope it makes sense, thank you!
Personal information removed by moderator. Please do not include any personally identifiable information in Community posts.
Best answer by GetUWiredView original