Google Sheets - Insert All Values
In Byteline, we can insert all data in Google Sheet using the node - Google Sheet - Insert All Values. Byteline allows users to easily integrate Google Sheets, in just a few clicks without the need for coding.
For this documentation, we are assuming you have already initiated a flow. Google Sheet node can work with any trigger. For creating a flow design, you can refer to the guide here.
Follow the step below to insert values in a Google Sheet.
Create
Step 1: Click on the add button to add the next node.
Step 2: Select the Google Sheet - Insert All node from the select node window.
Configure
Step 3: Click on the edit button to open the Google Sheet - Insert All node configuration window.
Step 4: A modal window will appear as shown below.
Step 5: Enter the Spreadsheet Id in the Spreadsheet Id box.
How to find the spreadsheet Id of your spreadsheet
Step 6: Open the Google Sheet in which you want to insert the data.
Step 7: Copy the spreadsheet Id from the spreadsheet URL, as shown below:
Step 8: Switch to the Byteline console to enter the spreadsheet Id in the spreadsheet Id input box.
Step 9: Enter the sheet name in the sheet name input box to insert the data in the particular sheet.
Step 10: Enter the Spreadsheet data, which should be in the format of a JSON array of arrays. (You need to mention a two-dimensional array here). You can use the Byteline Transform task node to easily convert the data to this format.
Step 11: Click on the Save button.
Step 12: The green color on the node indicates that the node has been successfully configured.
Your Google Sheet - Insert All Values node has been configured successfully. Feel free to connect us for any doubt.
Using Google Spreadsheet functions
You can use Spreadsheet formulas to populate your Google Spreadsheet data. But it can only be done using Google Sheets - Insert Columns task. So please use that task instead of this one.