Getting started
Rules Engine Widgets
Insert Row in Google Sheets
6 min
purpose to insert data dynamically into a google sheet directly from your workflow this node allows seamless automation between your application and google sheets, enabling you to record, log, or sync data in real time without manual entry problem statement manually updating google sheets can be repetitive and error prone, especially when managing workflow outputs like form responses, api data, or ai generated results the insert row in google sheets node automates this process — allowing any workflow to add structured data to your google sheets effortlessly requirements must have a valid google service account must include the service account json string credentials must have a valid spreadsheet id (from the target google sheet) must define the data to insert (either as static input or variable reference) requires proper permissions for the service account (edit access to the spreadsheet) use cases automatically log workflow outputs into google sheets save form submission data for tracking or analysis record api responses or user details dynamically maintain logs of automation runs or error events generate real time dashboards using google sheets as a backend outcome automatically inserts a new row of data into a specified google sheet, based on your workflow input variables how to use 1\ add the google sheets node drag and drop the insert row in google sheets node into your workflow canvas this node manages the connection to google sheets and the insertion of data 2\ configure the node go to the configuration tab field description example service account json string paste your google service account json credentials { "type" "service account", "project id" "simplita project", } spreadsheet id the unique id of your google sheet (found in its url) 1a2b3cd4ef5ghijklmnopqrstuvwxyz data to insert the data you want to add as a new row (can be json, array, or variables) \["john doe", "john\@example com", "active"] or {{formdata}} 💡 tip use dynamic variables such as {{apiresponse}} or {{userdata}} to insert real time workflow data 3\ select method switch to the method tab to choose the operation type method description test connection tests if your service account can access the specified google sheet insert data inserts a new row of data into the google sheet 🧩 use “test connection” first to confirm your credentials and permissions before inserting data 4\ save configuration once all fields are filled and the method is selected, click save to store your configuration node output output variable none