# I need to create an automation that automatically populates my google sheets with income statements data

**URL:** <https://community.make.com/t/i-need-to-create-an-automation-that-automatically-populates-my-google-sheets-with-income-statements-data/53511>\
**Category:** Questions\
**Tags:** google-sheets, api\
**Created:** [August 29, 2024, 7:52pm UTC](https://community.make.com/t/i-need-to-create-an-automation-that-automatically-populates-my-google-sheets-with-income-statements-data/53511 "2024-08-29T19:52:22Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [August 30, 2024, 2:20am UTC](https://community.make.com/t/i-need-to-create-an-automation-that-automatically-populates-my-google-sheets-with-income-statements-data/53511/2 "2024-08-30T02:20:09Z")

</div>

Welcome to the Make community!

I would suggest completing the **Make Academy** before jumping into building a complete scenario. If you need **specific assistance** when you are **building a scenario** it’s easier to help you then. Otherwise, you can also **hire a professional** by posting a request in the #Hire a Pro category.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

### Getting Started

- [Help Centre](https://www.make.com/en/help) | [Tutorials](https://www.make.com/en/help/tutorials.html) – Make “Manual”
- [Make Academy](https://academy.make.com) – Basics 101: Learn Make and get certified

### Help Centre Basics

- [Mapping](https://www.make.com/en/help/mapping/mapping) – What is mapping? What can I map?
- [Mapping with arrays](https://www.make.com/en/help/mapping/mapping-arrays) – How to map items in an array
- [Aggregate an array for mapping complex fields](https://www.make.com/en/help/tools/flow-control#customizing-the-output)
- **Date Format** : [tokens for `parseDate`](https://www.make.com/en/help/functions/tokens-for-date-time-parsing) | [tokens for `formatDate`](https://www.make.com/en/help/functions/tokens-for-date-time-formatting)
- [HTTP modules](https://www.make.com/en/help/tools/http) – Make a request, Get (download) a file
- [Webhooks](https://www.make.com/en/help/tools/webhooks) – Error Handling, Responding to webhooks

### Articles & Videos

- [Router Magic Formula](https://www.youtube.com/watch?v=4Q-5BsCtJu4) - YouTube
- [Error Handlers in Make](https://www.youtube.com/playlist?list=PLRE9E-rAD8U10mx2TRs54Nq1XJDdK9Kx4) - YouTube playlist
- [Getting started with OpenAI](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796) - How to setup and use OpenAI (ChatGPT) in Make
- [How to use Regex in Make](https://community.make.com/t/how-to-use-regex-in-make/202) - How to use pattern matching to extract the text you want
- [Webhooks – Make Academy](https://academy.make.com/courses/IntermediateC04) – tutorial on how to use Webhooks

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

* * *

P.S.: Did you know, [the concepts](https://community.make.com/t/make-academy-course-overview/29699) of about 70% of questions asked on this forum are already covered in the [Make Academy](https://academy.make.com). Investing some effort into it will save you lots of time and frustration using Make later!

---

_[View the full topic](https://community.make.com/t/i-need-to-create-an-automation-that-automatically-populates-my-google-sheets-with-income-statements-data/53511)._