Welcome to the Make community!
Previously-asked similar questions were asked on this forum, but were inconclusive:
You’ll need to use Google Sheets “Make an API Call” module to call the spreadsheets.batchUpdate endpoint to request for a “InsertDimensionRequest”.
You may get something that looks similar to this by following the above documentation (this example is for DeleteDuplicatesRequest)