- Python Version: Python 3.11.2
- gspread:Docs
- gspread-formatting:Docs
- service account.json:How to get json file
- sheet open key:where is key
1.pip install gspread,pip install gspread-formatting
2.create a sheet and rename it,input 5 titles in the first row
- There are 5 titles, but date will auto write.
- Images,it can have multiple pictures or no pictures.
- After modifying the code,you can change the title to what you want.
3.replace parameters in python file, your.json , yours sheet key , Typename , SubmittedBy , Description , Image_list and Tab_name
4.run python test.py,add a row
