Apps/Google Sheets/Import a CSV file into a sheet
Google Sheets
Google Sheets Action

Import a CSV file into a sheet

Import a CSV file into a spreadsheet, allowing you to specify the row and column of the spreadsheet to start the dump of data from the CSV file.

Start automating See how it's set up

200+ apps to connect·Tested & maintained tasks·Human support in English & Spanish

In detail

What it does and what it's for

This integration allows you to automatically import CSV files into Google Sheets spreadsheets, facilitating data management and analysis without manual intervention. You can specify the starting row and column to avoid overwriting existing information, ensuring precise and efficient integration.

Additionally, when executed, this operation provides useful data such as the ID of the newly inserted row, which can be used in the same automated task. This functionality is especially useful for keeping your spreadsheets updated and organized automatically.

Already using Botize?

Connect your Google Sheets

Add a profile to use it in your tasks. There's a step-by-step guide if you need it.

Add a new profile Step-by-step guide

Your profiles

Your connected Google Sheets accounts

These are the accounts you already have linked to Botize, ready to use in your tasks. You can reconnect or remove any of them.

Setup

Customization options

Fields you can adjust when using it in your automation.

URL of your sheet document
URL of your CSV file
Import CSV from row number
Import CSV from column
Exclude first CSV Row
Sheet selector (position or name)
Sheet number
Sheet name

Output data

Information provided

When executed, this operation delivers the following data, which can be used in the same automatic task.

  • Tags

  • New row ID {{new_row_id}}

Learn by watching

Video tutorials

Short videos where you watch a real task being built from start to finish.

Get inspired

Ready-to-use automations

Real tasks built with Google Sheets: switch them on in minutes and tweak them to your liking.

  • schedule → webhook_recurring
  • btzscraper → scrape
  • btzhtmlparser → map_node
  • btzcsv → array_to_csv
  • gspreadsheet → csv_to_sheet
Scrape a list of products from a website, export it to CSV, and import it into Google Sheets with affiliate links

FAQ

Frequently Asked Questions

How do I specify the row from which data will be inserted into Google Sheets?
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

Troubleshooting

Common Errors

The specified sheet does not exist in the spreadsheet
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.

Error: invalid_grant
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.

FAILED_PRECONDITION - This operation is not supported for this document
This error usually means that the file you're using is not in Google Sheets format, but instead saved as an XLSX (Excel) file.

To fix it, simply open the document in Google Drive and choose File > Save as Google Sheets. Once the file is in the correct format, Botize will be able to access it and run the automation properly.

Need a hand?

Real people behind it

Email us

info@botize.com
Monday to Friday from 7 a.m. to 1 p.m. (Spain).

Message us on Telegram

t.me/botizesupport
Monday to Friday from 7 a.m. to 1 p.m. (Spain).

Come with an idea.
Leave with an automation.

Create your first task in minutes. Do it once and forget about it forever.

Start automating