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.
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.
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.