Connect Feathery to Google Sheets to create new rows when your form is submitted. You may set up multiple Google Sheets actions at once.
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.
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.
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!
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.
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.
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!
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.