How do I write to specific tab?

[cameronjohnson-mz]

@rlamy or anyone who can help.

I currently have CSV data that I can write to the first tab, but how can look over the sheets and write to each one? And can someone update the documentation about spreadsheets because there's no information about it.

google_file_ref = next(iter(drive.ListFile({'q':f"mimeType = 'application/vnd.google-apps.spreadsheet' and '{google_file_ref_id}' in parents and trashed=false",
        'maxResults': 10,
        'corpora': 'teamDrive',
        'teamDriveId': drive_id,
        'includeTeamDriveItems': True,
        'supportsTeamDrives': True}).GetList()))
google_file_ref.SetContentString(response.content.decode('utf-8'))
google_file_ref.Upload()

[shcheklein]

I don't think we have an API to write to specific tab.