Create Google spreadsheet as template and duplicate the column to block using python

Question

Using python I was able to access google spreadsheet. How to duplicate block of columns, into the set of block of columns and keeping the same format.

For Example: Use rack layout and copy the block of columns into next available column and then populate data base on the certain rows.

Image in Right is the template and left is populate data.

I tried using below code to fetch the current setting but didn't work.

from gspread_formatting import *
rules = get_user_entered_format(sheet_instance, "A:D")
pprint(rules)
userdata = get_default_format(sheet)
pprint(userdata)