Python : Feed my google sheet with a .csv print

Hello friends !

I created my own code to download mutliple .csv files, merge them into one, connect to the Google Sheet API and then upload my sheet with the content of the .csv file.
I am at the end of my code, my sheet is beeing updated… but only with the last row of my .csv file (and then forgetting around 500 other rows :slight_smile: )
Can somebody help me on how to insert, for each row existing in my .csv, a new row in my google sheet (and no the ultimate one) ?
Thanks in advance !

import os
import glob
import pandas as pd
import csv

os.chdir("/Users/paul/Downloads")

extension = 'csv'
all_filenames = [i for i in glob.glob('*.{}'.format(extension))]

#combine all files in the list
combined_csv = pd.concat([pd.read_csv(f) for f in all_filenames ])
#export to csv
combined_csv.to_csv("combined_csv.csv", index=False, encoding='utf-8-sig')


with open('combined_csv.csv', encoding='utf8') as csv_file:
    tracking_numb = csv.DictReader(csv_file)
    print(tracking_numb)
    for tracking_numb in tracking_numb:
        print(tracking_numb['\ufeff\ufeffWaybill Number'], tracking_numb['Shipment Date'],tracking_numb['Recipient Country'], tracking_numb['Delivery Option'])

import gspread
from oauth2client.service_account import ServiceAccountCredentials

scope = ["https://spreadsheets.google.com/feeds",'https://www.googleapis.com/auth/spreadsheets',"https://www.googleapis.com/auth/drive.file","https://www.googleapis.com/auth/drive"]

creds = ServiceAccountCredentials.from_json_keyfile_name("/Users/paul/PycharmProjects/pythonProject2/creds.json", scope)

client = gspread.authorize(creds)

sheet = client.open("Python").sheet1

data = sheet.get_all_records()

insertRow = [tracking_numb['\ufeff\ufeffWaybill Number'], tracking_numb['Shipment Date'],tracking_numb['Recipient Country'], tracking_numb['Delivery Option']]
sheet.insert_row(insertRow, 2)