In this example, I will take the data from a sample marketing-tactic spreadsheet and use it to create several marketing proposals. In practice, this means that you can use Google Apps Script to customize Google apps and create new capabilities. According to Google, it allows you to “increase the power of your favorite Google apps” including Docs and Sheets. Google Apps Script is a simple scripting language based on JavaScript.
That might require typing (or at least cutting and pasting) data from the Google Sheet to each of 100 Google Docs manually, a very time-consuming task.Īlternatively, a marketer could write a short Google Apps Script and automate the process. But what if this marketing specialist needed to create proposals for 100 suppliers?
If the supplier accepts the proposal, it will pay co-op advertising, which in most cases is about half the cost of the planned promotion. One of the company’s marketing specialists is tasked with giving each supplier a marketing proposal. This example shows only four of them for February 2018. The following video demonstrates how to use the Lines, Shape, and Text tools, as well as rotate a shape from the Actions tool.The company’s Google Sheet contains a detailed marketing plan for each of its key suppliers. Select which tool you’d like to use, and then click and drag your cursor across the drawing board to create your shape or image. The process for using the drawing tools is more or less the same. Image (box with a mountain inside): Insert an image from your computer or Google Drive, or search for one on the internet.Text box (box with a “T” inside): Insert a text box to add text to your drawing.Shape (circle overlapping a square): Allows you to insert several premade shapes, including arrows, callouts, and equation symbols.
Lines (slanting line): Choose between several different line styles to draw.Select (cursor): Select a shape in your drawing.You can insert a ruler or guidelines from the drop-down menu. Zoom (magnifying glass): Zoom in or out on your drawing.Redo (curved arrow pointing right): Redo the most recently undone action.Undo (curved arrow pointing left): Undo the most recent action.Actions: Displays a menu with different actions, such as downloading the image, showing version history, copying, pasting, and rotating the image, and inserting Word Art.
0 kommentar(er)
