LinkStackHelp Center
Log in

Send workflow data to Google Sheets

Connect Google Sheets to insert rows, look up contact details, and update existing rows in workflows.

4 min read
In this article

Prepare and connect

  1. Create or open a Google spreadsheet. Use one table per worksheet. Put unique column names in row 1, starting at A1 with no gaps. A worksheet can have up to 100 columns for this action.
  2. In your workflow, click +, open Integrations, and browse the Google Sheets actions. Selecting an action checks the connection; if it is not connected, LinkStack saves your draft and opens the Google connector. After connecting, return to Integrations and choose the action again. For an existing Sheets step, click Connect Google Sheets or Reconnect Google Sheets directly in its panel; sign-in returns you to that step. Sign in to an account that can edit the spreadsheet and approve Sheets access. You can also connect from Settings → Integrations → Data.
  3. Return to LinkStack and check that Google Sheets shows Connected. If setup is unavailable, contact support. Google Calendar connects separately.
Google Sheets integration card under Data with the Connect Google Sheets button.
You can connect from Settings → Integrations → Data. This example shows the card before an account is connected.

Add the Insert row step

  1. Open your automation's workflow. Click +, open Integrations, and choose Insert row under Google Sheets. You can also search for it. Connect it after the steps that collect the details you want to save.
Workflow action picker with Google Sheets selected and Insert row, Get row by value, and Update row actions.
Choose Insert row to add a new row each time a contact reaches this step.

Choose the spreadsheet and worksheet

  1. Open Spreadsheet to select a file already authorized for LinkStack. If no files are authorized yet, Google's file picker opens directly. Otherwise, Choose another spreadsheet opens the picker so you can search your connected account.
  2. Prefer a link? Choose Paste spreadsheet URL from the dropdown, paste the URL or ID, and click Load spreadsheet. If Google's picker opens first, cancel it to reveal the dropdown. If the file has not been authorized yet, select it in Google's picker to grant access.
  3. Open Worksheet and choose the tab that should receive new rows. The column names from row 1 appear below.
Spreadsheet dropdown with sample files, Choose another spreadsheet, and Paste spreadsheet URL options.
Choose an authorized spreadsheet, browse Google for another file, or paste a URL from this menu. The file names shown are sample data.
Insert row editor with a sample spreadsheet loaded and the Worksheet menu showing Leads and Archive tabs.
Sample data: Workflow leads is the spreadsheet file, and Leads is the worksheet tab inside it.

Map the columns and publish

  1. For each column, choose a contact field, a custom field, all tags, a specific tag, latest message text, time added, or a typed value. Contact fields include names, email, phone, social profile details, timezone, locale, subscription status, and contact dates. Leave blank skips a column. Specific tags write true or false; all tags writes a comma-separated list. Missing contact values are blank.
  2. Review the mappings and publish the workflow. Each new workflow run reaching the step adds a row, even for a returning contact. There is no extra plan upgrade for the Sheets action; your normal automation limits still apply.
Example column mappings: Name to Full name, Email to Email, Tags to All tags, Interest to Product interest, and Source to the typed value Instagram DM.
Sample mappings combine contact details, tags, a custom field, and a fixed source label. Collect the contact's answers before this step.

Get row by value

Bring spreadsheet data into LinkStack. For example, match a contact's email to a row and save that row's membership tier to a custom field for later workflow steps.

  1. Choose Google Sheets: Get row by value. Load your spreadsheet and choose a worksheet with column headers in row 1.
  2. Choose a Lookup column and Lookup value. Use a contact field, custom field, tag, workflow value, or typed value. An email address or contact ID makes a useful unique key.
  3. Once the match rule is set, Save to contact appears. Choose a Column to save, then its contact field. Use Add another column for each additional value you need. Remove a mapping with its X button. A contact field can receive one column per action.
  4. You can save names, email, phone, social username, social platform, timezone, locale, and custom fields. Contact IDs, social account IDs, profile image URLs, subscription status, and activity dates are available as sources only. Use a tag action to change tags.
  5. Publish the workflow. The first exact match supplies the values. Blank cells preserve the contact's existing fields; zero and false are saved. If no row matches, the workflow continues without changing the contact.
Get row by value matches the Email column to the contact's Email and saves only Membership tier to a custom field.
Sample data: set the match rule first, then add the columns to bring into LinkStack.

Update row

  1. Choose Google Sheets: Update row, load the spreadsheet, and choose a worksheet.
  2. Set the Lookup column and Lookup value to identify the existing row. Update columns then appears. Choose a Column to update, then its contact field, custom field, tag, workflow value, or typed value. Add another column as needed.
  3. Only selected columns change; other cells keep their values and formulas. Use the X button to stop updating a column. A selected empty value clears that cell. Publish to update the first matching row. If no row matches, nothing changes; this action does not insert a new row.
Update row matches Contact ID and updates only the Membership tier column from a contact custom field.
Sample data: only the selected Membership tier column changes. Add another column when needed.

Check the result

  • Workflow preview and Test skip Google Sheets actions, including lookups and contact-field changes. After publishing, use a real trigger and check the selected worksheet or contact fields.
  • Inserted and updated values are saved literally, including phone numbers and text beginning with an equals sign. They do not run formulas.
  • Lookups search the first 10,000 data rows, starting at row 2, and compare against the displayed cell value. Text matching is case-sensitive. Use unique lookup values. If a larger worksheet has no match in that range, the step stops and asks you to use a smaller worksheet.
  • If all mapped values are empty, the step fails instead of inserting an empty row. Collect and save answers before the Sheets step.

Columns, access, and retries

  • Insert row prevents duplicate writes when the same workflow step is retried. It does not deduplicate separate runs by contact, email, or spreadsheet contents: a second comment that starts a new run can add another row. Update row changes an existing match but does not create a missing row.
  • If you add, remove, rename, or reorder columns, open the step and click Refresh columns. Mappings follow unchanged column names; removed or renamed columns need new mappings. Review and publish again. A changed header row stops writes until the published mappings are updated.
  • Renaming a worksheet tab is supported because the step tracks its ID. Deleting and recreating the tab requires selecting it again.
  • When many contacts reach Sheets steps at once, LinkStack queues them until the connected Google account and shared Google project have capacity. Workflows using the same Google account share its allowance across spreadsheets. Each workflow resumes automatically at the same step; these waits do not use up its five retries.
  • If Google still returns a rate limit, the step retries up to five times with increasing delays. Other failures stop the run and appear in automation activity. If a timeout leaves the result uncertain, check the sheet before running the contact again so you do not create a duplicate.
  • Reconnect in Settings → Integrations if access expires or the spreadsheet dropdown asks you to reconnect. New connections access only files you choose. After upgrading an older connection, use Choose another spreadsheet to select each file used by your workflows, including any saved file that reports an access error. Your mappings stay saved.
  • For access errors, check that the connected Google account can edit the spreadsheet, that you have selected it in Google's picker, and that the worksheet is not protected.
  • Disconnect removes LinkStack's saved connection. Existing spreadsheet rows, imported contact values, and workflow mappings remain, and later Sheets actions fail until you reconnect. You can also revoke Google-side access in your Google account.

Related articles

Still need help?

Support & feedback