from pprint import pprint

import re

import httplib2

import apiclient.discovery

from oauth2client.service_account import ServiceAccountCredentials

CREDENTIALS_FILE = 'file.json'

spreadsheet_id = 'enter yours'

credentials = ServiceAccountCredentials.from_json_keyfile_name(

CREDENTIALS_FILE,

['https://www.googleapis.com/auth/spreadsheets',

'https://www.googleapis.com/auth/drive'])

httpAuth = credentials.authorize(httplib2.Http())

service = apiclient.discovery.build('sheets', 'v4', http = httpAuth)

with open('file.data', 'r') as f:

nums = f.read().splitlines()

number_of_ct=len(nums)

number_of_ct -= 1

#number_of_ct=4

print("Containers on server:", number_of_ct)

i = 1

while number_of_ct > 0:

ct_info = re.split(r'[|]', nums[number_of_ct])

ia = str(i)

iA = "A"

gg = str(20)

gG = ":G"

range = (iA + ia + gG + gg)

values = service.spreadsheets().values().batchUpdate(

spreadsheetId=spreadsheet_id,

body={

"valueInputOption": "USER_ENTERED",

"data": [

{"range": range,

"majorDimension": "ROWS",

"values": [[ct_info[1], ct_info[2], ct_info[3], ct_info[4], ct_info[5], ct_info[6], ct_info[7]]]}

]

}

).execute()

i += 1

number_of_ct -= 1