Looking for a google spreadsheets and automation formulas expert
Need to write some formulas that will extract numbers from an excel spreadsheet automatically every day.
The spreadsheets are created from a google form
And create a separate file with the date as name, and add some formulas
End of every week create a week excel file with numbers of the last 7 days and combine cells with same name and add totals
All resulting excel files ( 8 per week ) must be automatically emailed to me
Please only react if you speak good english
And have done automations before