with the sheets’ add-ons gallery, you can add reports, analytics, data analysis, and even email scheduling tools to your spreadsheets in a couple clicks. just click tools -> create a form in google sheets, and the google forms editor will open with a new form that’s automatically connected to your spreadsheet. our app integration tool connects to the most popular form and survey apps—including typeform, wufoo, gravity forms, and more—and can copy your new form results to a google sheets spreadsheet automatically. you can edit the columns to pull in any data you want, then export it to google sheets or download as a spreadsheet. it connects your spreadsheets to a wide variety of web apis to import and analyze data manually or on a schedule. for a simpler way to see just the data you need—and turn it into reports—the google analytics sheets add-on can pull in any analytics data you want and save it to spreadsheet tables. it can then translate your whole sheet or a selection automatically, with the new text showing up in seconds. it even adds a link to the finished document for each row in your spreadsheet, so you can re-open them again easily later.
you can then customize the style, save it, and add it to new spreadsheets with a click. want your spreadsheet to show only the data you need? you’ll first add your data models to bigml, then install the add-on for google sheets and connect it with your api key. you can even add forms to gather text, images, and signatures on the go for a full mobile data collection tool built around your spreadsheet. import your google contacts—or list your own emails—then select a file from google drive that you want to send to the list. you can simply share the script code or publish the add-on to google apps to share it–with just your team or with any google sheets user. zapier can then copy data to and from your spreadsheet and the other apps you use for a seamless workflow. you’ll learn how to do that with google sheets in the next chapter, with detailed tutorials on how to format spreadsheets, create contacts, and send emails right from your spreadsheet with custom code that works the way you want.