Claspo

When creating widgets in Claspo, you can add an integration with Google Sheets. It allows exporting your data collected in Claspo to a specified spreadsheet. 

Note: Before starting your integration in Claspo, you need to have a Google account.

When creating a new widget, the Integration step suggests adding a new integration. Proceed as follows:

Select Google Sheets from the list of apps.

The New Google Sheets integration pop-up window appears.

Click the Google button. You will be redirected to the Google Sign in page.

Enter your login and password and click Log in.

- The Google access permission does not expire and remains valid unless you revoke it.
- If you experience authorization issues, click Reauthorize to repeat the authorization process.
   

In Claspo, open the New integration sidebar and click Open Google Sheets.

In Google Sheets, copy the URL of the blank spreadsheet.

Go back to Claspo and paste the URL in the Document URL field.

In the Field mapping section, type the column name in the Google Sheets field corresponding to the field name in your Claspo widget. Click Show more fields to expand the list.

In the Static fields section, type the static field names and the corresponding field values.

Add more static fields as required by clicking Add static fields, then click Done.

1. Click Add integration.
 Adding new integration
2. Select Google Sheets from the list of apps.
 Selecting Google Sheets
 The New Google Sheets integration pop-up window appears.

3. Click the Google button. You will be redirected to the Google Sign in page.
4. Enter your login and password and click Log in.
 
 Note: 
 - The Google access permission does not expire and remains valid unless you revoke it.
 - If you experience authorization issues, click Reauthorize to repeat the authorization process.
 
5. In Claspo, open the New integration sidebar and click Open Google Sheets.

6. In Google Sheets, copy the URL of the blank spreadsheet.
7. Go back to Claspo and paste the URL in the Document URL field.

8. In the Field mapping section, type the column name in the Google Sheets field corresponding to the field name in your Claspo widget. Click Show more fields to expand the list.

9. In the Static fields section, type the static field names and the corresponding field values.
10. Add more static fields as required by clicking Add static fields, then click Done.

Your Google Sheets spreadsheet is now integrated with Claspo. The new data entered in the Claspo widget fields will be written into the corresponding mapped columns in your Google Sheets spreadsheet.

You can edit the Google Sheets configuration at any time in the Claspo dashboard, the Widgets menu by selecting a required widget and pressing the Edit button on the right side.