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 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, to get contact information.
• A button in a repeated strip.
  • Add an On Click Action (strip interactivity) to insert the repeated strip.
• A button to trigger the Titan Flow to Google Sheets.
  • Add an On Click Action with a Flow node.

Add input fields

1. Click the + icon to open the list of elements.
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 the contact information, such as first and last names.

Add a repeated strip

1. Click the + icon to open the list of elements.
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. Click the + icon to open the list of elements.
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. Click the + icon next to the Start node to open the Add Node screen.

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

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

12. If necessary, add a tag and click the Insert button. The Repeat Interactivity node is added to the screen.
13. Click the Apply button.

Add a trigger button

1. Click the + icon to open the list of elements.
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. Click the + icon next to Start to open the Add Node screen.

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

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

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

10. Save and Preview the project. The data is shown.
11. Click 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.