Pull data from Google Form into Excel spreadsheet
Budget: $30 – $250 USD
I need to pull the data from my Google Form into an existing Excel Spreadsheet based on the client's first and last name that I enter into the spreadsheet.
I will need to sync and populate all yellow, highlighted cells in these sections:
*****
Body Stats:
*****
All except:
-weight used for calculations
Activity level would be based on their answer to "How many days are you currently doing cardio"
Program Type = Do you have an idea of the nutrition style you're interested in? (Google Form)
Keto = Ketogenic Nutrition
Intermittent fasting = Intermittent fasting
Custom/other = Intermittent fasting with ketogenic nutrition OR Balanced macro nutrition with evenly spaced
meals throughout the day
Trans IF Keto = IF "Are you transitioning genders?" = "Yes - male to female" THEN select this option BUT if they have selected one of the other options above for nutrition style, then please override this with their nutrition style selection.
*****
Diet and food
*****
Allergy information would match the Google form
Diet type would match the form
Meal frequency will stay at 4 and be the default
*****
Cardio Adjustments
*****
Cardio level = Cardio exercise experience (in Google Form)
Cardio type = leave blank in spreadsheet please
*****
Workout Adjustments
*****
Include Workouts? = What type of resistance training would you prefer to do? (Google Form)
IF Google Form = None, I would rather just do cardio THEN input for spreadsheet in C88 = No
Workout location = Workout location (Google Form) :
Answers 1-3 = "Gym" in spreadsheet
Answer 4 = "Home" in spreadsheet
Workout type = What type of resistance training would you prefer to do? (Google Form)
Please match with the appropriate dropdown in the Excel spreadsheet
Requires customization: Please leave this blank
Workout Experience Level = What is your resistance training experience level? (Google Form)
Workout Frequency = please leave blank for now
Link to client's workout sheet = please leave blank for now
Tracking spreadsheet = please leave blank for now
I will need to sync and populate all yellow, highlighted cells in these sections:
*****
Body Stats:
*****
All except:
-weight used for calculations
Activity level would be based on their answer to "How many days are you currently doing cardio"
Program Type = Do you have an idea of the nutrition style you're interested in? (Google Form)
Keto = Ketogenic Nutrition
Intermittent fasting = Intermittent fasting
Custom/other = Intermittent fasting with ketogenic nutrition OR Balanced macro nutrition with evenly spaced
meals throughout the day
Trans IF Keto = IF "Are you transitioning genders?" = "Yes - male to female" THEN select this option BUT if they have selected one of the other options above for nutrition style, then please override this with their nutrition style selection.
*****
Diet and food
*****
Allergy information would match the Google form
Diet type would match the form
Meal frequency will stay at 4 and be the default
*****
Cardio Adjustments
*****
Cardio level = Cardio exercise experience (in Google Form)
Cardio type = leave blank in spreadsheet please
*****
Workout Adjustments
*****
Include Workouts? = What type of resistance training would you prefer to do? (Google Form)
IF Google Form = None, I would rather just do cardio THEN input for spreadsheet in C88 = No
Workout location = Workout location (Google Form) :
Answers 1-3 = "Gym" in spreadsheet
Answer 4 = "Home" in spreadsheet
Workout type = What type of resistance training would you prefer to do? (Google Form)
Please match with the appropriate dropdown in the Excel spreadsheet
Requires customization: Please leave this blank
Workout Experience Level = What is your resistance training experience level? (Google Form)
Workout Frequency = please leave blank for now
Link to client's workout sheet = please leave blank for now
Tracking spreadsheet = please leave blank for now