Python Forum
Confused on how to go about writing this or doing this...
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Confused on how to go about writing this or doing this...
#1
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?
Reply
#2
You should be able to use selenium to control the browser to automate the process.

It would be easier if we had the google doc with the required fields.

This is the basic concept:
https://python-forum.io/Thread-Web-Scraping-part-1
https://python-forum.io/Thread-Web-scraping-part-2
Reply
#3
I have a general idea...

Can we get the program to go something from this (just random data I made up and put onto Google Sheets):

https://ibb.co/DYDXR8k

to something like this:

https://ibb.co/XyR4RVk

We could do this through Python and Google API? Or is this not possible? Or too difficult?
Reply
#4
(Feb-10-2020, 07:00 AM)pythonforumuser Wrote: We could do this through Python and Google API? Or is this not possible? Or too difficult?
Look at API Python usage for Docs and Sheets.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Confused with 'flags' tester_V 10 1,018 Apr-12-2021, 03:03 AM
Last Post: tester_V
  Simple Tic Tac Toe but I'm confused Izith 1 537 Sep-26-2020, 04:42 PM
Last Post: Larz60+
  I am really confused with this error. Runar 3 669 Sep-14-2020, 09:27 AM
Last Post: buran
  Confused by 'break' in the official documents Chuck_Norwich 2 764 Apr-12-2020, 09:26 PM
Last Post: Chuck_Norwich
  I always get 'None' returned. Confused. What did I miss? jpezz 2 980 Apr-07-2019, 10:06 AM
Last Post: jpezz
  Confused by order of operations ward 4 1,164 Jan-22-2019, 08:53 PM
Last Post: Larz60+
  Confused by this modulo equation VikramSuh 3 1,349 Sep-05-2018, 12:43 PM
Last Post: VikramSuh
  I am new to python , i am confused with this syntax , please help aankrose 3 1,299 Aug-03-2018, 06:49 PM
Last Post: aankrose
  Still confused about how passing arguments works RedSkeleton007 3 1,713 Apr-25-2018, 11:01 AM
Last Post: snippsat
  understanding lists....I'm very confused mepyyeti 7 2,431 Dec-23-2017, 02:06 PM
Last Post: mpd

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020