Google Sheets

Overview

Connect Feathery to Google Sheets to create new rows when your form is submitted. You may set up multiple Google Sheets actions at once.

What you need

Background

Google Sheets is a cloud-based spreadsheet software developed by Google, part of the Google Drive suite of productivity tools. It allows users to create, edit, and collaborate on spreadsheets in real-time, similar to Microsoft Excel.

Key Features of Google Sheets:

  1. Cloud-Based: Google Sheets is accessible through a web browser, enabling users to create and edit spreadsheets from any device with an internet connection. Changes are automatically saved to the cloud, ensuring that users always have access to the latest version of their documents.
  2. Collaboration: Google Sheets facilitates real-time collaboration, allowing multiple users to work on the same spreadsheet simultaneously. Users can see each other's edits in real-time, chat within the document, and leave comments for discussion.
  3. Templates: Google Sheets offers a variety of pre-designed templates for common spreadsheet tasks, such as budgeting, project management, and scheduling. These templates provide a starting point for users to create their own customized spreadsheets.
  4. Formulas and Functions: Google Sheets supports a wide range of formulas and functions for performing calculations and data analysis. Users can use built-in functions such as SUM, AVERAGE, and VLOOKUP, as well as create custom formulas to manipulate data.
  5. Data Visualization: Google Sheets provides tools for creating charts, graphs, and pivot tables to visualize data and identify trends. Users can customize the appearance of charts and graphs, as well as filter and sort data within pivot tables.
  6. Integration with Google Services: Google Sheets integrates seamlessly with other Google services, such as Google Drive, Gmail, and Google Calendar. Users can easily import data from other Google apps and export spreadsheets to various file formats, including Microsoft Excel.
  7. Add-ons: Google Sheets supports add-ons, which are third-party extensions that add additional functionality to the software. Users can install add-ons for tasks such as data analysis, project management, and document automation.
  8. Offline Access: Google Sheets offers offline access through the Google Chrome browser and the Google Sheets mobile app. Users can create and edit spreadsheets offline, and changes will be synced to the cloud once an internet connection is reestablished.

Common Use Cases for Google Sheets:

  • Data Management: Users use Google Sheets to organize and manage data, such as lists, inventories, and financial records.
  • Project Planning: Teams use Google Sheets for project planning and tracking, including task lists, timelines, and resource allocation.
  • Data Analysis: Users perform data analysis and reporting using Google Sheets' built-in formulas, functions, and visualization tools.
  • Budgeting and Financial Planning: Individuals and businesses use Google Sheets for budgeting, expense tracking, and financial planning.
  • Collaborative Work: Teams collaborate on spreadsheets for various purposes, such as brainstorming sessions, meeting agendas, and shared documents.

Overall, Google Sheets is a versatile and user-friendly spreadsheet software that offers powerful features for creating, editing, and collaborating on spreadsheets. Its cloud-based nature and integration with other Google services make it a popular choice for individuals and teams looking for a flexible and collaborative solution for managing data and information.

How to set up

Create a Google Sheet spreadsheet that optionally has column headers.

Navigate to the Feathery form that you want to connect to Google Sheets. Click on the Integrations tab.

Open the Google Sheets integration and choose the Feathery form event to trigger the Google Sheets action. Your options are when someone completes the form, reaches a specific step of the form, or whenever data is received from your end user (partial submissions, data enrichment, etc.)

Authorize and connect your Google account.

Choose either the Add a Row or Sync to Sheet action. The Add a Row action allows you to map your Feathery fields to the relevant columns of your spreadsheet, while Sync to Sheet will autocreate column headers and send your data unmapped.

Click Connect. Your integration is now live and ready to go!

Actions

The available Google Sheets actions are Add to Row and Sync to Sheet.

The Sync to Sheet action can be used on an empty Google Sheet. It will autogenerate the column headers to be the Feathery field IDs. Each submission will be added as a row of the Google Sheet, with each entry corresponding to the respective field ID column. You can also toggle Update existing row, which allows you to specify a condition where if the search value (a Feathery field) matches a value in the Google Sheets column, that row will be updated with new data instead of a new row in the Google Sheet being created.

The Add Row action can be used on a Google Sheet that already has column headers defined. You may map Feathery fields to various columns in your sheet, and each form submission will be added as a row of the Google Sheet based on your column mapping.

What’s a Rich Text element?

The rich text element allows you to create and format headings, paragraphs, blockquotes, images, and video all in one place instead of having to add and format them individually. Just double-click and easily create content.

Static and dynamic content editing

A rich text element can be used with static or dynamic content. For static content, just drop it into any page and begin editing. For dynamic content, add a rich text field to any collection and then connect a rich text element to that field in the settings panel. Voila!

How to customize formatting for each rich text

Headings, paragraphs, blockquotes, figures, images, and figure captions can all be styled after a class is added to the rich text element using the

"When inside of" nested selector

system.

This is a H6

This is a Link

  • This is a list item
  • This is another list item here
Get started with
Feathery

Request access to stay in the loop

Thanks for joining
the waitlist
Done
Oops! Something went wrong while submitting the form.