How do I add a "live" Google Doc to an Activity?

Let’s say you have an Excel Spreadsheet or any sort of document that you need to share with your users. Instead of sending out a static table, one you would need to replace and re-share every time you need to make an adjustment, you can instead use a Google Doc that will automatically update. This is called a “live” spreadsheet. Then, you can embed the Google Doc into a TargetSolutions Custom Activity. This way, every time you update the document, the activity will automatically update as well and you can assign your users the most current information.

1. Create a Google Doc at https://docs.google.com/ - it’s free! You can either enter your information, or import it from an existing file from your computer. Once it is ready to be shared, click File and then Publish to Web.

1.01.png

2. On the Publish to the Web window, click the drop down arrow 'Published content & settings' and click Start Publishing.

2.01.png

3. From the Publish to the web page, click on the Embed tab.

3.01.png

Highlight the code outlined in the image below, right click, and select Copy.

4.01.png

4. Open up a Word Document or a blank email, right click, and Paste your code.

5. You will see all the quotes in that code. Before you insert an embed code into the Activities Builder, you need to remove all of these. This is very important! Now highlight your new quote-free code, right click, and Copy.

6. Log into TargetSolutions. Under Administration, open the Activities Builder. Scroll down the list to find the desired activity (or create a new one).

3.01.png

7. Under Free Form Components on the right, select Text. Right click and paste in the code. Check again to make sure there are no quotes! Then click Submit.

4.01.png

8. You will see the live sheet is in your activity. You can now add other Components to the activity, or leave it as in.

5.01.png

Note: If you would like to change the size of the spreadsheet, simply add width=500 height=400 (entering the width and height you want) to the text in between 'iframe' and 'src', as shown below.

7.01.png

9. This is how the activity will look to the assigned users. Test it out by assigning it to yourself. Now go in the Google Doc and make a change. When you go back to the activity, you will see that it has automatically updated.