How to Manage Data Collected via AMP Forms
When you create emails with AMP forms in eSputnik, you can receive and store users’ responses using the built-in data service in Stripo.email. A data service collects information in the internal storage of Stripo.email and transfers it to external storages via Zapier.
How to Create a Data Service in Stripo.email
Stripo.email allows free storage of responses from AMP forms.
1. Create an account in Stripo and log in.
2. In the toolbar on the left, click Data > Create your service.
3. Enter the service name and description. Other fields will be filled automatically. Leave Stripo storage enabled. If you plan to use external platforms for data storage via Zapier, enable External storage resources.
4. Copy the generated URL address.
5. Go to your eSputnik account and open the corresponding email with the AMP form. Click ϟHTML to open the settings. Insert the copied URL in Service for data collection.
The data service is created.
All data provided by recipients will be stored in your Stripo account and can be downloaded as a CSV file.
How to Transfer Data to External Platforms via Zapier
You can transfer data from AMP forms to external storages such as Google Sheets. To do this, you need to set up a connection between your Google account and Stripo via Zapier.
You'll have to pay Zapier for the data transfer if monthly tasks exceed 100 (1 task equals data transfer to one line of the sheet).
1. In your Stripo account > Data > Data storage, disable Stripo storage.
2. Enable External storage resources.
3. Add the webhook URL. See below how to get it.
How to Get a Webhook URL
1. Create an account in Zapier or log in.
2. Click MAKE A ZAP.
3. Enter zap’s name.
4. In Built-In Apps, select Webhooks by Zapier.
5. In Choose an Event, select Catch hook and click Continue.
6. Copy the generated URL.
7. Insert it to Webhook URL in your Stripo account.
8. Copy the URL address.
9. Go to your eSputnik account and open the corresponding email with the AMP form. Click ϟHTML to open the settings. Insert the copied URL in Service for data collection.
9. Go back to Zapier > Customize Request and click Continue. Click Test trigger > Skip test and click Continue.
10. In Your Apps, choose Google Sheets.
11. Choose Create Spreadsheet Row and click Continue.
12. Click Sign in to Google Sheets and allow Zapier access to your account.
13. Create a Google Spreadsheet where the corresponding data will be exported: name, email address, answer, etc.
14. In Drive, select My Google Drive, and choose the necessary spreadsheet and worksheet. Click Continue. Zapier will extract field names from the worksheet.
15. Test the connection: the data from the form should be transferred to the corresponding columns of the table.
16. If everything works fine, click TURN ON ZAP.
If you want to transfer data to both Stripo and external storage, enable both toggles. Add a link to the Stripo data service in the template in eSputnik. The answers will be sent to the internal Stripo store and to Google Sheets via Zapier.