My client and I are on separate networks but I need to send daily and weekly figures to them so they can post those figures to a company dashboard (spreadsheet graphs). Right now, I have to compile the figures, email them my spreadsheet, have them open my and their separate spreadsheets and copy and paste that in and reopen the graphs. What I thought I could do is develop them a spreadsheet that would use the Get Data From Web feature. This would pull from a Google Sheet that is automatically updated when I update my personal spreadsheet. I am basically looking to daisy chain my spreadsheet, Google Sheets and my clients spreadsheet so that my updates flow downstream to them. It would save a lot of steps but I am not sure exactly what I am doing but here we are.
Thanks.
Thanks.