Import a CSV file into a sheet

To import data into a Google Sheets sheet, you always need to specify the row from which the data insertion will begin. This is important to ensure that the data does not overwrite existing information. If you’re unsure which row to start from, we recommend first performing an additional step to find out how many rows with data are in the column you're interested in. This will give you the exact number of the last row with data, and you can specify the next row number so that the data is imported correctly, right after the existing data.

You can use this function to count the total number of rows with data in a specific column: Count total rows in a column

The automatic task has provided a sheet name or number that does not exist in the spreadsheet.

Please verify that there is indeed a sheet with the same name or number in the spreadsheet as specified in the task.

There is an issue related to authentication or authorization for accessing Google Sheets with the user account you specified.

Please ensure that the Google account mentioned in the automated task has access to the Google Sheets document or reconnect your Google account to Botize.