Export Data to Google Sheets

Business Background

Export data from your web project to Google Sheets.

Titan Solution

Titan lets you export data from multiple strips in your web project to Google Sheets.

How to Video

Coming soon.

How to Guide

Create a Web project that contains the following:

• A strip with input fields, for instance, First Name and Last Name.
  • Map Salesforce fields to the input fields, for instance, get contact information.
• A button in a repeated strip.
  • Add a On Click Action (strip interactivity) to insert the repeated strip.
• A button to trigger the Titan Flow to Google Sheets.
  • Add a On Click Action with a Flow node.

Add input fields

1. Select the + icon to add a new element to a Web project.
2. Under Input, drag Text Field elements to the canvas.
3. Use the Text Field element’s Gear icon to open the Settings screen.
4. Under Salesforce, configure a Get integration for each element, for instance, get Contact information such as First and Last Names.

Add a repeated strip

1. Select the + icon to add a new element to a Web project.
2. Under Strip, drag a strip element to the canvas.
3. Use the Strip element’s Gear icon to open the Settings screen.
4. Under Content, select the Repeat checkbox.

5. Select the + icon to add a new element to a Web project.
6. Under Button, drag a button element to the repeated strip.
7. Use the Button element’s On Click Action icon to open the On Click Action screen.

8. Select the + icon next to Start to open the Add Node screen.

9. Under Element Interactivity, select the Strip Interactivity option and select the Next button.

10. Use the Strip Element drop-down list to select the Repeat Strip option.
11. Select the Insert radio button and select the Next button.

12. Add a tag if necessary and select the Insert button. The Repeat Interactivity node is added to the screen.
13. Select the Apply button.

Add a trigger button

1. Select the + icon to add a new element to a Web project.
2. Under Button, drag a button element to the strip.
3. Use the Button element’s On Click Action icon to open the On Click Action screen.

4. Select the + icon next to Start to open the Add Node screen.

5. Under System action, select the Flow option and select the Next button.

6. Use the drop-down list to select the Titan Flow project that you created as part of the prerequisites.
7. Select the Next button.

8. Add a tag if necessary and select the Insert button. The Flow node is added to the screen.
9. Select the Apply button.

10. Save and Preview the project. The data is shown.
11. Select the button to trigger the Flow to Google Sheets.

Example in Google Sheets:

Any regular input field that is not part of the repeated strip will be added to each row.