Feb-09-2020, 02:47 AM
Currently we have a Google Forms that people fill out with (NAME), (ADDRESS), and (CITY, STATE, ZIP CODE)
It automatically goes to 3 cells in google sheets that are next to each other. We then have to manually copy and paste each part of mailing address and then open Google Docs and paste it like this on a label:
NAME
ADDRESS
CITY, STATE ZIP
And with 100s of these a week, it just takes a lot of my time up.
Ideal Way: I want to create a program that will automatically take the google forms data and have it go onto Google Docs and create labels. Then I can just hit print. I am not sure if this is possible? This would be absolutely ideal.
If not, I would make google forms get 3 sets of input (NAME), (ADDRESS), (CITY, STATE ZIP) and then put it into 1 cell but put each one on a different line (all in 1 cell) so I can easily just copy and paste into on a label.
How would I set up this python program to run and do this for me? Can we do the ideal way?
It automatically goes to 3 cells in google sheets that are next to each other. We then have to manually copy and paste each part of mailing address and then open Google Docs and paste it like this on a label:
NAME
ADDRESS
CITY, STATE ZIP
And with 100s of these a week, it just takes a lot of my time up.
Ideal Way: I want to create a program that will automatically take the google forms data and have it go onto Google Docs and create labels. Then I can just hit print. I am not sure if this is possible? This would be absolutely ideal.
If not, I would make google forms get 3 sets of input (NAME), (ADDRESS), (CITY, STATE ZIP) and then put it into 1 cell but put each one on a different line (all in 1 cell) so I can easily just copy and paste into on a label.
How would I set up this python program to run and do this for me? Can we do the ideal way?