Pygsheets – Adding Data to Google Spreadsheets

I was facing a 5 second time delay adding data to Google Spreadsheets while using the gpread library. Web search revealed the same with other users as well.

Web search led me to pygsheets, a user seemed to claim that it is much faster when writing data into Google Spreadsheets, but my experience has been different.

Pygsheets takes a minimum 9 seconds to save a record compared to 5 seconds with gpread. If a coder has had a better experience, kindly do share your feedback.

There are few tutorials online for pygsheets, I am assuming the slowness of the system might be the reason.

import pygsheets
from oauth2client.service_account import ServiceAccountCredentials

scope = ['', '']
creds = ServiceAccountCredentials.from_json_keyfile_name('client_secret.json', scope)

client = pygsheets.authorize(service_file='client_secret.json')
workbook ="Spreadsheet_File_Name")

worksheet1 = workbook.worksheet_by_title("Sheet1")



worksheet1.insert_rows(row=rowcount,number=1, values=row_value,inherit=True)


‘int’ object is not callable

If you get an error message like one of these:

TypeError: 'int' object is not callable
TypeError: 'float' object is not callable
TypeError: 'str' object is not callable

This probably means that you are trying to call a method when a property with the same name is already available.

Simply change the method call into a property access.

For example, if a line like this causes an error message like one of those above:

Try changing the line to this:


PyInstaller Error – expected str, bytes or os.PathLike object, not NoneType

Operating System: Windows 10

Python Version: 3.7.2

PyInstaller Version: 3.4

This is a fairly annoying error without much information to go by. But luckily for us, a responsible coder has provided a solution to this.

The solution lies in making changes to the file in the Project Folder


Rename the existing file to and replace this file with the one available on GitHub as provided below.

Converting to exe using PyInstaller should work perfectly now.

Let me know how you fared.

Pyinstaller Error – Failed to execute script pyi_rth__tkinter

Operating System: MacOS

Python Version 3.7

Pyinstaller Version 3.4

Pyinstaller can run into some minor issues with MacOS, but solving it might take you longer if you do not get the right guidance. We have kept the solution simple to help you resolve the issue faster.

Below is a snippet of the error

Traceback (most recent call last):
File “PyInstaller/loader/rthooks/”, line 28, in <module>
FileNotFoundError: Tcl data directory “/var/folders/nl/2wxh3z313l129zpzq2f8ww5m0000gn/T/_MEILUmJRc/tcl” not found.
[2195] Failed to execute script pyi_rth__tkinter

The Error Message basically refers to a file that cannot be found. In most cases, this file may not be necessary to run your application. The only way to know it is to refer to the file

The file can be found under the venv folder of your project.


You will find a simple IF Statement that returns an error if a specific file is not found in the tk or tcl directory. You can comment the IF Statement as provided below and try running your PyInstaller code once again.

#if not os.path.isdir(tcldir):
    #raise FileNotFoundError('Tcl data directory "%s" not found.' % (tcldir))
#if not os.path.isdir(tkdir):
    #raise FileNotFoundError('Tk data directory "%s" not found.' % (tkdir))

From 1 Order a week, to 3 Orders a day with Google AdWords

In 2016, I started my own Resume Writing Service as a part-time venture. I went at it with a lot of thought. Built a professional website, wrote appealing content and published several blogs. But that wasn’t enough to get the phones ringing. I was receiving an average 1 order per week through SEO and about 2-3 orders per week through word-of-mouth and other sources. Well, that does not sound much of a business, does it?

It was time to get back to the drawing board. It was not my business that was the problem. It was just my marketing strategy that needed a rethink. With my small business idea, spending heavily on marketing would be foolish. I had to choose a Paid advertising medium that was smart.

Google AdWords was my preferred Paid advertising choice and within a few weeks of research my ads were live on Google.

With just USD 100 per month on Google AdWords, I was able to generate an approximate 3 orders per day with a phenomenal Click-Through-Rate of 8 to 10%.

Screenshot 2018-08-22 22.37.51

The average Click-Through-Rate of Google AdWords is about 2%. Anything above 2% is considered above average CTR.

With a successful Google AdWords Campaign, I was able to keep my Marketing Budget to below 2% of the Revenue Share. The recommended digital marketing budget for most companies my size is anywhere between 5% to 8%.

If you are wondering why I chose Google AdWords, and not Facebook, Instagram or other mediums. Well, I will leave that for another blog post.

Sophos Auto Update Error – Installation could not upgrade the current version of product SAVXP – Windows 7 64-bit

Copy the destination files in the bullet list to folder  C:\Program Files (x86)\Sophos\Sophos Anti-Virus\

  • native.exe from C:\ProgramData\Sophos\AutoUpdate\Cache\savxp\native\amd64\
  • All files from C:\ProgramData\Sophos\AutoUpdate\Cache\savxp\drivers\onaccess\win7_amd64\
  • All files from C:\ProgramData\Sophos\AutoUpdate\Cache\savxp\drivers\boottasks\win7_amd64\
  • All files from C:\ProgramData\Sophos\AutoUpdate\Cache\savxp\drivers\sdcfilter\win7_amd64\

Right-Click Sophos Icon from the taskbar and run update now. Sophos should update now and the latest IDE should appear in the C:\Program Files (x86)\Sophos\Sophos Anti-Virus\ folder